Home > Interview Questions > SQL Server > What is Difference between Function and Store Procedure

What is Difference between Function and Store Procedure

by angappan   on 06/12/2013   Category: SQL Server   |  Level: Beginner   |  Views: 2881    |  Points: 25     |  Bronze 

1. Function must be return the result set values. or single column values
2. Function only input parameters
3. Function can use in Sql Statement Having/Where/Select sections anywhere.
4. Function can return values so we can use joins in any other tables
5. Function can called from procedure

Store Procedure
1.Store procedure no need to return values.
2.Store procedure allow input/output parameters
3.Store procedure not allow where/Having/select sections anywhere in Sql statements
4.Procedure cann't call from function

« how to create Simple Invoice in Asp.net c# with Databse .
» What is Execute Scalar? How many values are return? single value or Multiple value
Post Question  |  Question Home

Recent Posts

User Responses

No response found, be the first to review this question.

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts