Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Stored procedure and function?
- 9 Answers
- 13494 Views
- I also Faced
- E-Mail Answers
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
How many types of triggers are there in update panel?
What is s2s tracking?
How long do session variables last?
What is the extension of master page in asp.net?
Explain the page lifecycle of an asp.net mvc? : asp.net mvc
How would you get asp.net running in apache web servers? Explain it's limitations.
Explain the steps needed to be performed in order to create an animation in xaml?
What is bound controls
How do I publish my asp.net application to my isp's web server?
when a request is made in Life cycle of ASP.NET page .
calling result set one procedure to anothar procedure in sql2000
How can we identify that the page is post back in asp net?
Explain the basic functionality of garbage collector?
Do gac'ed assemblies have fulltrust?
What is the importance of aspnet_isapi.dll, inetinfo.exe andaspnet_wp.exe in the page loading process.
