Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Stored procedure and function?
- 9 Answers
- 13845 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
Where do we store our connection string in asp.net application?
How would you implement inheritance using c#?
What is localhost in asp.net?
What is validation in asp.net?
Is web config mandatory?
What is strong-typing versus weak-typing?
IN an ASP.NET Web application if there is any error, how can you debug?
Describe the difference between inline and code behind - which is best in?
Explain why datareader is useful?
What is repository pattern in mvc.net? : asp.net mvc
What are web beacons used for?
What are the major built-in objects in ASP.NET?
How can we Validate a Controls in ASP.NET page using JavaScript?
In the Repeater control which way you can edit?
What is a windows service?
