What is the difference between a Stored procedure and function?
Answer Posted / ruchi aggarwal
1.Functions can be used in select, where or case statement
whereas sp cannot.
2.In Functions we cannot modify the base table information.
DML statements cannot be used.
3.In Function non deterministic funstions are not used
whereas we can use them in sps eg:GETDATE
4.No Multiple result sets can be returned from function
whereas we can do this in sp.
5.Error handling is restricted. RAISERROR and @@ERROR are
invalid from inside User Defined Functions
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What are the session management techniques asp net?
Explain Features in ASP.NET
For which does this Codebehind="MyCode.aspx.cs" is relevent to ?
Define data caching?
Define machine.config in .net?
1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?
What is a nested masterpage in asp.net 2.0? Can there be a master page inside a masterpage?
Explain Apache web servers ? How can you get ASP.NET running in Apache web servers - why should you do this?
What are the media types of http requests and response?
Explain the advantages of caching?
Distinguish between Server-side and Client-side code?
How to deploy/publish webservices?How many ways?Plz explain me
What does aspcompat="true" mean?
What is the difference between cache and cookies?
What websites use asp.net?