Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76194 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / tmp
the main advantages is Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached and used again to when the same SP is executed again)
http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by coalesce in sql server?
What is the maximum size of a row in sql server?
How do I connect to sql server database?
explain different levels of normalization? : Sql server database administration
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Is BCNF better than 2NF & 3NF? Why?
Explain system rowset functions?
How to perform key word search in tables?
Can you edit the .rdl code associated with a linked report?
What is sql sandbox in sql server?
How to change the name of a database user?
What are the restrictions that views have to follow?
How to provide default values to stored procedure parameters?
How are the unique and primary key constraints different?
What is set nocount on and what is set nocount off?
