which is the best one in stored procedure and view?
stored procedure can return value?
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.
Jiteendra SampathiraoPosted Nov 12, 2010, 4:03 AM
2. Function must return a value but in SP's its an optional.
3. Function parameters are always IN, no OUT parameters is possible.
4. Using Stored Procedure we can handle number of queries(Insert, update, delete )........
Refer this link to know abt SP's:
http://www.c-sharpcorner.com/UploadFile/jitendra1987/3848/Default.aspx?ArticleID=274124a2-1c6a-45fb-8ba4-c459c2fbf223
If this post helped you, then tick the "Do you like this Answer" checkbox which is placed at above this post.
Suthish NairPosted Nov 12, 2010, 2:48 AM
Should I use a view, a stored procedure, or a user-defined function?
Jiteendra SampathiraoPosted Nov 12, 2010, 1:45 AM
Stored procedure is a precompiled execution statement. So it reduce the traffic.
There are 3 types of procedure.
1) in parameter
2) out parameter
3) in/out parameter
View is a virtual table.
View is derive from base table.if we delete base table view also automatically will delete.
There are 2 types of view
1) Simple view.
2) Complex view.
We can get the return value from Stored Procedure.
If this post helped you, then tick the "Do you like this Answer" checkbox which is placed at above this post.