What is the difference between a Stored procedure and function?
- 9 Answers
- 12300 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
Why do we use asp.net?
Explain the Session state management options available with ASP.NET?
How long does an http session last?
Explain server-side scripting?
What is difference Between Authentication and authorization?
What is autopost?
How does session work in asp net?
What is boxing and unboxing in asp.net?
How can you identify that the page is post back?
Differentiate between early binding and late binding.
What is the purpose of asp.net?
6. Tell us about a time when you failed to meet a deadline. What were the repercussions?
What is page request in asp.net?
Why is string called immutable data type?
What is a postback url?
