What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / prashant
1>Procedure can return zero or n values whereas function can
return one value which is mandatory.
2>Procedures can have input,output parameters for it whereas
functions can have only input parameters.
3>Procedure allow select as well as DML statement in it
whereas function allow only select statement in it.
4>Functions can be called from procedure whereas procedures
cannot be called from function.
5>Exception can be handled by try-catch block in a procedure
whereas try-catch block cannot be used in a function.
6>We can go for transaction management in procedure whereas
we can't go in function.
7>Procedures can not be utilized in a select statement
whereas function can be embedded in a select statement.
Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
What are the differences between clustered and non-clustered index?
Explain the cursor lock types?
What encryption security is available in sql azure?
Give main differences between "Truncate" and "Delete".
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How to recompile stored procedure at run time?
What is report rendering ?
what are triggers? : Sql server database administration
What is an execution plan?
What do you understand by hotfixes and patches in sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is raiseerror? What is raiseerror?
What is the use of “join” in sql server?
Does server sql treat char as a variable-length or fixed-length column?
What is open database communication (odbc)?