Ankit Agarwal
What is difference Stored Procedure and Function?
By Ankit Agarwal in SQL Server on Oct 01 2012
  • balaji R
    Oct, 2012 12

    stored procedure: 1.return more than one output value 2.We can call the function in the stored procedure 3.Allows select as wel as the DML statement like insert,update and delete 4.try catch is applicable Function: 1.Must return a single value. 2.We cant call the stored procedure inside the function 3.Allows only select statement 4.No try catch is allowed

    • 1
  • Ruchi H
    May, 2013 15

    1. Procedures can have input/output parameters for it whereas functions can have only input parameters. 2. Procedure allows select as well as DML statement in it whereas function allows only select statement in it. 3. We can go for transaction management in procedure whereas we can't go in function. 4. Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.

    • 0
  • Vithal Wadje
    Oct, 2012 4

    Store procedure is the Group of Sql statements which is used to perform Insert,upadte,delete (CRUD)operations

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS