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
Functions are not compile but their execution plans are cached.
See more SQL Server Interview Questions
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.