Loading ...

Stored procedures versus user defined function in sql server.

 /5
0 (0votes)
  • Procedure can return zero or n values whereas function can return one value which is mandatory.
  • Procedures can have input,output parameters for it whereas functions can have only input parameters.
  • Procedure allow select as well as DML statement(Create,Drop,Alter) in it whereas function allow only select statement in it.
  • Functions can be called from procedure whereas procedures cannot be called from function.
  • Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
  • We can go for transaction management in procedure whereas we can't go in function.
  • Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.

 

Comments (1)

   
shaitender
Can u explain with a example ..thanks
11/30/2009
 · 
by

Top Posts