Difference between Stored Procedure and Functions

Question

what is most important difference Stored procedure and Functions?

Pravin More · Answer

Hi Lucy, I think most important difference is that In Function You cant do Insert,Update,its not allowed in function instead you can do it in sprocs. *when to use function:-They can only be use to select records. they can be called very easily from within standard SQL,like this .................SELECT dbo.functionname('Parameter1') . *when to use Sprocs:-we can use to for simple reason like select statement, or as complex reason like long script that adds, deletes, updates, and/or reads data from multiple tables in a database. In simple language,Comparing with programming concept, Stored Procedure is Like program and function is like method of that program. Thank You,Hope this info will help you. Pravin.

Javeed M Shaikh · Answer

there are many differences but the one at present in my mind is: Function must return a value and Stored procedure it is optional Function can have only IN param, while stored procedure can have IN and OUT I think Function gets compiled each time on the call and stored procedure compile only once.

Difference between Stored Procedure and Functions

Answers (2)