What is Store Procedure?? and how and Why we use store Procedure ??
and what is difference between Store Procedure and function in SQL Server???
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sam HobbsPosted May 14, 2011, 6:50 PM
Vilas GitePosted May 14, 2011, 6:30 AM
Please check it,
Store Procedure : http://msdn.microsoft.com/en-us/library/aa174792(v=sql.80).aspx
Function : http://msdn.microsoft.com/en-us/library/ms186755.aspx
How and Where, you used Store Procedure : http://www.c-sharpcorner.com/UploadFile/73ba73/7161/?ArticleID=63b40f15-b9a8-4e27-a4f1-0625b4be4c55
Hopes you will satisfied with.
Dorababu MekaPosted May 12, 2011, 3:49 AM
The name function comes from math. It is used to calculate a value based on input.
A procedure is a set of command which can be executed in order.
In most programming languages, even functions can have a set of commands. Hence the difference is only in the returning a value part.
But if you like to keep a function clean, (just look at functional languages), you need to make sure a function does not have a side effect.
Check this article
http://www.c-sharpcorner.com/UploadFile/skumaar_mca/Diff-Proc-Func08062009071904AM/Diff-Proc-Func.aspx