Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Stored procedure and function?
- 9 Answers
- 13886 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
benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks
Is oauth for authentication or authorization?
Why and where this web.config file is used?
Which .NET framework supports Web API?
Can you edit data in the Repeater control? Which template must you provide, in order to display data in a Repeater control? How can you provide an alternating color scheme in a Repeater control? What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?
How does asp page work?
Can master pages be nested?
Why does my asp.net file have multiple tag with runat=server?
What is cross page posting? How is it done?
Describe the differences between the lifecycles of Windows services and Standard EXE?
Which method is used to enforce garbage collection in .net?
Explain file-based dependency and key-based dependency.
How can you apply a theme to your asp.net application?
In which situation can you not use a viewstate?
What is cookieless session id explain in brief?
