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
Do you know what are the restrictions that views have to follow?
What is use of except clause? How does it differ from not in clause?
How to select an exiting database using mssql_select_db()?
Are resultset updatable?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Explain intellisense for query editing
Do you know how to implement service broker?
Tell me when is the update_statistics command used?
What is wide table?
Explain trigger and trigger types?
Explain what is sql server english query?
What are four major operators that can be used to combine conditions on a where clause?
What is the largest component inside a field?
What is the difference between web edition and business edition?
What is the difference between dbcc indexdefrag and dbcc reindex?