Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8804 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / plabana
1.StoreProcedure may return avalue may not return a value
but Function returns the value.
2.SttoreProcedure can be called independently using exec
keyword ,Function are called using select stmt.
3.StoreProcedure can create a table but can't return a table
where as Function can return a value.
4.Transaction related stmt can be handeled by StoreProcedure
Where as it can;t be handeled by Function.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Why normalization is used?
How each E-R model constructs can be mapped to the relational model?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Define clusters?
How to drop an existing schema in ms sql server?
What is the advantage of sql server?
How to run sql server 2005 books online on your local system?
What are the operating modes in which database mirroring runs?
What is the difference between a local and a global temporary table?
How does normalization work?
Mention what are the different types of ssrs reports?
What is the difference between the application object and session object?
What is difference between delete & truncate commands?
What is the concept of optimization?
Why and when do stored procedure recompile?
