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 and executed every time when it is called.
1. Functions that return tables can be treated as another rowset. This can be used in JOINs with other tables.
2.Exception can be handled by try-catch block in a Procedure whereas try-catch block cannot be used in a Function.
3. Procedures can not be utilized in a SELECT statement whereas Function can be embedded in a SELECT statement.
4. Procedure allows SELECT as well as DML(INSERT/UPDATE/DELETE) statement in it whereas Function allows only SELECT statement in it.
Subscribe to:
Post Comments (Atom)
-
Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) ...
-
Web API 1. This is the new framework for building HTTP services with easy and simple way. 2. Web API is open source an ideal ...
-
There are many technologies used to build .NET Web applications. To build effective application-level authentication and authorization s...
No comments:
Post a Comment