The most important Different in Stored Procedure & Function

Question

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.?

Vinay Singh · Answer

We can use UDF in SP but we can not use SP in UDF

Jisny Av · Answer

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 .

Joginder Banger · Answer

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.

Krishna Rajput Singh · Answer

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

Nitin Sontakke · Answer

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.

Ehsan Sajjad · Answer

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.