What is the difference between a stored procedure and a user
defined function in sql server?
Answers were Sorted based on User's Feedback
Answer / kumar.t
1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.
2. Select Clause we cann't use stored procdure. but
fucntion we can use.
3. XMl Clause contain we can use stored procdure. but
function we cann't use.
4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.
By
Kumar.T
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / samant
1.For user defined function one must have to specify it's
return type while in stored procedure it is not mandatory.
2. u can use function in expression but not stored
procedures
Is This Answer Correct ? | 3 Yes | 0 No |
What is row_number()?
Is a primary key unique?
What is the Disadvantage of indexed sequential file.
What are the different types of queries?
How to download and install microsoft .net framework version 2.0?
What is #table in sql server?
What is sql server english query?
What does it mean to be in union?
What is instead of dml trigger?
What is a trigger?
what is difference between view and Dip.
What is normalization process?