The most important Different in Stored Procedure & Function

Hariharan Krishnamoorthi

10y970

There are lot differents are between Stored procedure & UDF. But, what is most important different from SQL Stored procedure and User defined function. Only one different, it should be valid and why it is important different.?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
We can use UDF in SP but we can not use SP in UDF
+1
Jisny Av10y ago
Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values). Functions can have only input parameters for it whereas Procedures can have input/output parameters . Functions can be called from Procedure whereas Procedures cannot be called from Function.
+1
Krishna Rajput Singh10y ago
http://www.c-sharpcorner.com/UploadFile/2072a9/store-procedure-vs-function-in-sql-server/

http://www.tutorialplus.net/Articles/difference-between-stored-procedure-function-sql-server.htm

http://www.dotnet-tricks.com/Tutorial/sqlserver/7EDL150912-Difference-between-Stored-Procedure-and-Function-in-SQL-Server.html
0
Nitin Sontakke10y ago
From the tone of the question, it is not clear if you genuinely asking the question or just testing our knowledge. Anyway!
Apart from the TWO major differences mentioned already, another major difference is you cannot use output returned from sp in a join but can use returned from user defined TVF.
Furthermore you only mention UDF but don't differentiate between Scalar function and TVF.
0
Ehsan Sajjad10y ago
Stored Procedure can return multiple result sets while Function can only return single result set which means that in Stored procedure you can have multiple select statements while in Function you cannot have that.
0
Joginder Banger10y ago
Hi Hariharan,
In store procedure you can insert,update,delete data but in function only select data.
this is a main difference between store procedure and function.
+1