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)
Python -3
Lists It is used to store Collection of data. Lists are created using square brackets: List Items Order cannot be changed. It can have dup...
-
Using ng bind directive: <html> <script src="angular.min.js"></script> <body> <div ng-a... -
Union: It is used to combine the data from two sets. Example: display the list of all jobs available in dept 20 and 30 select job from em...
-
Creating a Table To store data into the relational database you must create a table in the database and for this purpose you need to use the...
No comments:
Post a Comment
Thank you for visiting my blog