Difference between function and stored procedure

March 20, 2015March 11, 2015 by Satya Prakash

There are many difference between function and stored procedure. In this article we will discuss about the difference between function and procedures in context of SQL Server. Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called.But Function is compiled … Read more