Which of the following is a way to build dynamic sql statements?
(a) Writing a query with parameters
(b) Using sp_executesql
(c) Using EXEC
(d) All of the mentioned
This question was posed to me in homework.
Enquiry is from Dynamic SQL topic in chapter Developing with SQL Server of SQL Server