Question

Point out the wrong statement.

(a) A stored procedure is nothing more than prepared SQL code

(b) We can create a Stored Procedure using the Create proc statement

(c) We can create a Stored Procedure using the Create stor_proc statement

(d) All of the mentioned

The question was posed to me in examination.

Query is from Built in Stored Procedures in section Developing with SQL Server of SQL Server

Answer 1

Correct answer is (c) We can create a Stored Procedure using the Create stor_proc statement

Explanation: Benefit of Stored Procedures is that they are executed on the server side and perform a set of actions, before returning the results to the client side.