insert a variable and table value as parameters to procedure
-1
votes
1
answer
56
views
-sql
CREATE PROCEDURE [dbo].[GetFruitName]
(
@quantity int
)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO Table1(fname,fprice,quantity)
SELECT f.name,f.price from table2 f,@quantity
END
but am unable to pass @quantity
Asked by shivraj Jacky
(1 rep)
Oct 17, 2019, 05:57 AM
Last activity: Oct 17, 2019, 06:46 AM
Last activity: Oct 17, 2019, 06:46 AM