SQL Server Performance Forum – Threads Archive

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.

Read about them sql server help file also Madhivanan Failing to plan is Planning to fail

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.

]]>