Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8785 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 left outer join and right outer join?
Tell me what is the significance of null value and why should we avoid permitting null values?
What are sub reports and how to create them?
what are constraints? : Sql server database administration
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Do you know data definition language, data control language and data manipulation language?
Explain what is log shipping?
What do you understand by a stored procedure?
What is the difference between update lock and exclusive lock?
What is the purpose of floor function?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Can we deploy SSRS reports on our personal website?
What encryption security is available in sql azure?
When would you use sql joins?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
