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
I have an external link in my application say www.xyztest.com. Today this site works on http protocal. Tommorow it may run on https. So i cant hardcore the protocal in the site. When a user clicks on the link how can i know if the external site works on http or https and takes him to that place?
How can u debug your .net application?
What symbol specifies the beginning of a query string?
What is OSI layer? Explain different layers.
When Cookies are expired in ASP.NET?
What is the benefit of WebAPI over WCF?
Where code pages are used?
Define static function?
Write a code snippet to implement the indentation in json in web api.
Explain a program using razor view engine to create a simple application? : asp.net mvc
WSDL means?
What is difference between ispostback and autopostback in asp net?
What are session state modes in asp.net?
What is the question mark in a url?
What is caching? What are different ways of caching in asp.net?