Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8594 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
Explain what are page splits? : SQL Server Architecture
How to get the definition of a user defined function back?
What is molap and its advantage? : sql server analysis services, ssas
How to use user defined functions in expressions?
How to create sub reports?
Can an entity have two primary keys?
What is the new security features added in sql server 2016? : sql server security
what is a self join? : Sql server database administration
How do clustered indexes store data?
How to remove duplicate rows from table?
How can I track the changes or identify the latest insert-update-delete from a table?
How to link tables in sql server?
What is the process of normalising?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is the difference between count () and rowcount ()?
