diffenrnece between sp and functions/.....

hi friends.....
whats r differnces between the stored [procedures and functions...

- consider a function is a peice of code applied to every row of your query statement

- a stored proc is a peice of code that you execute that performs some logic. It cannot be used in a referenced in a query statement.

http://qa.techinterviews.com/q/20060804232021AA6mjm4
http://hemantgirisgoswami.blogspot.com/2007/02/difference-between-stored-procedure-and.html


MohammedU.
Moderator
SQL-Server-Performance.com

All postings are provided “AS IS” with no warranties for accuracy.