Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8949 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 a filestream?
Can you explain powershell included in sql server 2008?
What is the difference between drop table and truncate table?
Explain few examples of stored procedure over triggers?
Explain about SQL server 2005?
How does index makes search faster?
what is a check constraint?
What does <> symbol mean?
Tell me what do we need queues in sql service broker?
How the authentication mode can be changed?
What are relationships and mention different types of relationships in the dbms
What is the use of sql profiler in sql server 2012?
How to receive returning result from a query?
How to name query output columns in ms sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
