Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22189 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / arunvs
stored procedure when executed generates execution plan
once and next time when it is executed again it will use
the generated execution plan,it does not generate it again.
sp used to solve a business logic
Function compiles from the beginning and prepares the trace
or execution each time it is called.function can be used to
calculations
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are the features of Embedded SQL
what is the system function to get the current user's user id? : Sql server database administration
How exceptions can be handled in sql server programming?
what protocol both networks use? : Sql server database administration
What new changes are being made in SQL Server?
What are the differences between local and global temporary tables?
What are the types of indexes?
Why we use trigger in sql server with example?
explain different types of backups avaialabe in sql server? : Sql server database administration
What is data modification?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is self join in sql server joins?
What triggers long term care?
How can delete duplicate records in cte in sql server?
Explain what are various ways to enhance the ssrs report?
