diffenrnece between sp and functions/….. | SQL Server Performance Forums

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
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.