what is the difference between procedure and function.
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
How can you list all the columns in a database?
What is conditional split?
What new changes are being made in SQL Server?
What is meant by indexing?
New concepts of sql server 2005 use in your project.
What is difference between rollback immediate and with no_wait during alter database?
What is coalesce and check constraint in sql server?
What is a print index?
Explain the properties of a relational table?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is the sql server agent?
How to link tables in sql server?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How can a database be repaired?
What are recommended options to be used while using db mirroring? : sql server database administration