Alexandre Aubrey

Programming language:Whatever

2021-07-25 06:20:23

0

Q:

output parameter use with stored procedure

Senor CMasMas

Code: Whatever

2021-08-02 08:27:18

        
            
        
     CREATE PROCEDURE uspFindProductByModel (
    @model_year SMALLINT,
    @product_count INT OUTPUT
) AS
BEGIN
    SELECT 
        product_name,
        list_price
    FROM
        production.products
    WHERE
        model_year = @model_year;

    SELECT @product_count = @@ROWCOUNT;
END;

0

Tags

• use
• procedure

Related

• exec stored procedure with named parameters
• execute stored procedure without db set
• search stored procedures