SP_EXECUTESQL or EXEC(@SQL)

[BikeBoy20032004]

Hi,

Is there any PERFORMANCE benifit in SP_EXECUTESQL vs.
EXEC(@SQL)? I know SP_EXECUTESQL allows you to pass params, but as far as recompiles/performance are they different?

Thank you

 

[SQLSister]

Using sp_executesql is recommended over using the EXECUTE statement to execute a string. Not only does the support for parameter substitution make sp_executesql more versatile than EXECUTE, it also makes sp_executesql more efficient because it generates execution plans that are more likely to be reused by SQL Server.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[BikeBoy20032004]

thanks sister