Question

Point out the wrong statement.

(a) Stored procedure can accepts input and output parameters

(b) Stored procedure can returns multiple values using input parameters

(c) Using stored procedure, we can Select,Insert,Update,Delete data in database

(d) None of the mentioned

I got this question in a national level competition.

My question comes from Built in Stored Procedures in portion Developing with SQL Server of SQL Server

Answer 1

Right choice is (b) Stored procedure can returns multiple values using input parameters

To explain: Stored procedure can returns multiple values using output parameters.