Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76858 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
Write query to return all rows sql?
What is store procedure? How do they work?
How can I get data from a database on another server?
If no size is defined while creating the database, what size will the database have?
Characterize join and name diverse sorts of joins?
What is co-related sub query?
Mention the differences between substr and charindex in sql server.
What is SubQuery in SQL Server 2008
Where are full-text indexes stored?
Where the sql logs gets stored?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to list all dsn entries on your local machine using odbc_data_source()?
What are out-of-range errors with date and time literals?
