Which of the following is way to build dynamic sql statements ?
A. Writing a query with parameters
B. Using sp_executesql
C. Using EXEC
D. All of the mentioned
Answer:A
Which of the following is way to build dynamic sql statements ?
A. Writing a query with parameters B. Using sp_executesql C. Using EXEC D. All of the mentioned
Explanation:SQL Server offer three ways of running a dynamically built SQL statement.