what is the difference between procedure and function.
- 4 Answers
- 7812 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 stretch database in sql server?
What is pivot and unpivot?
How to find related tables in sql server?
How to provide default values to stored procedure parameters?
explain how to create a new schema in a database? : Sql server database administration
Which is better statement or preparedstatement?
What is the current pricing model of SQL Azure?
How to get nth highest salary from employee table.
What is replication with database mirroring? : sql server database administration
What is the use of group by clause?
how will add additional conditions in sql?
What are the different types of triggers in SQL SERVER?
How to insert data with null values?
How do you handle datasets larger than 50 gb?
Explain cursor as data base object?
