Question

Point out the wrong statement.

(a) The @stmt parameter in sp_executesql is a Unicode string containing valid SQL commands

(b) The input type @Type is passed as the first parameter to sp_executesql

(c) We can specify the parameters for both input and output in sp_executesql

(d) None of the mentioned

I got this question in semester exam.

I would like to ask this question from Dynamic SQL topic in section Developing with SQL Server of SQL Server

Answer 1

Correct choice is (b) The input type @Type is passed as the first parameter to sp_executesql

To explain: The output type @retType is passed as the second parameter to sp_executesql.