Interview Questions
1. What is the difference between EXEC and sp_executesql?
- sp_executesql allows for statements to be parameterized therefore it’s more secure than EXEC in terms of
SQL injection. sp_executesql can leverage cached query plans. Temp tables created in EXEC cannot use temp
table caching mechanism.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment