what is the difference between function and stored procedure

Question

c#

Yadagiri Reddy · Answer

Functions ---------- 1) can be used with Select statement 2) Not returning output parameter but returns Table variables 3) You can join UDF 4) Cannot be used to change server configuration 5) Cannot be used with XML FOR clause 6) Cannot have transaction within function Stored Procedure ----------------- 1) have to use EXEC or EXECUTE 2) return output parameter 3) can create table but won't return Table Variables 4) you can not join SP 5) can be used to change server configuration 6) can be used with XML FOR Clause 7) can have transaction within SP

Lawrence Pond · Answer

SQL functions can be Table Valued Function returns table Scalar Values Function single result Aggregate Function System Functions Stored procedures Typcially functions are the building blocks single unit of work that a stored procedure uses and the stored proc is the container to do the work. store procedures can return one or more results by using output field types Functions call from inline sql select fConcatString(n.FirstName, n.LastName ) from Names n ; where you cannot run a stored procedure from a select statement.

Abhishek Kumar · Answer

Aditya, Please follow the below link http://sqlhints.com/2012/06/16/difference-between-stored-procedure-and-user-defined-function-in-sql-server/ Abhishek

Ranjit Powar · Answer

http://www.dotnet-tricks.com/Tutorial/sqlserver/7EDL150912-Difference-between-Stored-Procedure-and-Function-in-SQL-Server.html

what is the difference between function and stored procedure

Answers (4)