Sample Header Ad - 728x90

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