Difference between Function and Procedure-in general?
Answer Posted / dharmendra nonia
Function and Stored Procedure both are precompiled objects
in databases but there is some difference between UDFs and
Stored Procedure such as--
1)Function Must be return at least one value but stored
procedure may or may not.
2)We can use Function for only data manipulation but stored
Procedure is used to Manipulation as well as Modification
of Data on tables.
3)We can't use DML statements inside Function but In stored
Procedure, we can use DML statements.
4)In stored Procedure, we can pass INPUT and OUTPUT
parameter but Function accept only input parameter and
return a value.
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
what's the maximum size of a row? : Sql server database administration
What is the use of partition by in sql server?
Mention the differences between sql server and mysql.
Can an entity have two primary keys?
Explain how to integrate the ssrs reports in application?
What is statement level trigger?
How to divide query output into multiple groups with the group by clause in ms sql server?
What are the different methods available under sqlcommand class to access the data?
What is normalization? Explain different forms of normalization?
Can group functions be used in the order by clause in ms sql server?
How to create indexed view?
What are the common performance issues in sql server?
What is unpivot?
Can I use sql azure as a backup with log shipping or database mirroring?
How can we delete Duplicate row in table?