__________ is used to build the code dynamically and execute it.
A. sp_addmessage
B. sp_dropmessage
C. sp_altermessage
D. sp_executesql
Answer:A
__________ is used to build the code dynamically and execute it.
A. sp_addmessage B. sp_dropmessage C. sp_altermessage D. sp_executesql
Explanation: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.