Is SQL Server functions are Pre-compiled statements?

 SQL Server stored procedures are compiled when they are first run, and also the first time they are run after a structure change to tables which they reference. You can also manually recompile them with sp_recompile or with the "WITH RECOMPILE" option when executing them from Management Studio.

Functions are not compile but their execution plans are cached.


See more SQL Server Interview Questions
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar