The calling syntax for sp_executesql is as follows:
A. sp_execute <@stmt> [<@param1 data_type>,<@param2 data_type>, …]
B. sp_sql <@stmt> [<@param1 data_type>,<@param2 data_type>, …]
C. sp_executesql <@stmt> [<@param1 data_type>,<@param2 data_type>, …]
D. sp_executesql [<@param1 data_type>,<@param2 data_type>, …]
Answer:A
The calling syntax for sp_executesql is as follows:
A. sp_execute <@stmt> [<@param1 data_type>,<@param2 data_type>, …] B. sp_sql <@stmt> [<@param1 data_type>,<@param2 data_type>, …] C. sp_executesql <@stmt> [<@param1 data_type>,<@param2 data_type>, …] D. sp_executesql [<@param1 data_type>,<@param2 data_type>, …]
Explanation:Using sp_executesql to run dynamic statements gives us a couple advantages over EXEC that are worth noting.