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