Stored procedure | Function |
A procedure need not return a value | Function must return a value |
Returns values using out parameters | Function returns values using return expression |
They supports optional parameters | they does not support optional parameters |
You can call a function from stored procedure | You cannot call a stored procedure from a function |
Procedure can’t be called in select statement | Function can be called in select statement |
Try and catch statements can be used | Try and catch statements cannot be used. |
Tuesday, June 10, 2014
Stored Procedure and Function
Subscribe to:
Post Comments (Atom)
Kubernetes
Prerequisites We assume anyone who wants to understand Kubernetes should have an understating of how the Docker works, how the Docker images...
-
Super aggregates: Are used to calculate aggregates of aggregates There are two super aggregates functions Roll Up Cube When there is a singl... -
SOLID principles allows object oriented programming implementation in an efficient better way into project development S-->Single R... -
With this example you can create pdf and print pdf. If You are using ASP.NET MVC , PDF can be created by using Rotativa Rotativa is a ...
No comments:
Post a Comment
Thank you for visiting my blog