Which of the stored procedure used for dynamic SQL is prone to attacks ?
A. xp_executesql
B. executesql
C. sp_execute
D. sp_executesql
Answer:A
Which of the stored procedure used for dynamic SQL is prone to attacks ?
A. xp_executesql B. executesql C. sp_execute D. sp_executesql
Explanation:sp_executesql executes a Transact-SQL statement or batch that can be reused many times, or one that has been built dynamically.Run time-compiled Transact-SQL statements can expose applications to malicious attacks.