EXEC vs SP_EXECUTESQL Performance

20 votes

3 answers

33634 views

sql-server t-sql performance dynamic-sql exec query-performance

                          Recently we used a sql code reviewing tool against our database. It is suggesting to use SP_EXECUTESQL instead of EXEC. 

I know SP_EXECUTESQL helps us to avoid sql injection. Is there any difference in performance when using EXEC vs SP_EXECUTESQL.

Asked by Pரதீப் (1419 rep)

Feb 22, 2017, 09:27 AM
Last activity: May 15, 2022, 10:11 PM

EXEC vs SP_EXECUTESQL Performance

Related Questions