Question

__________ is used to build the code dynamically and execute it.

(a) sp_addmessage

(b) sp_dropmessage

(c) sp_altermessage

(d) sp_executesql

The question was asked in unit test.

I need to ask this question from Stored Procedure topic in section Developing with SQL Server of SQL Server

Answer 1

Right choice is (d) sp_executesql

To explain I would say: You can execute SQL dynamically using either the EXECUTE T-SQL statement or the sp_executesql stored procedure. sp_executesql is the more flexible of the two though because it supports using parameters.