Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8625 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
What is postgresql server?
Define ACID properties in a Database?
How to trouble shoot if unable to connect SQL Server
what is denormalization and when would you go for it? : Sql server database administration
What protocol does sql server use?
What is open database communication (odbc)?
What is a View ? Can we insert, Update and delete a view?
Can you explain different types of joins?
What is the difference between clustered index and primary key?
Ways to improve the performance of a SQL Azure Database?
How to create a dml trigger using create trigger statements?
What is explicit mode in sql server?
How to modify an existing stored procedure in ms sql server?
what are acid properties? : Sql server database administration
What is 2nf in normalization?
