the main advantages is Execution Plan Retention and Reuse (SP are compiled

Difference between writing SQL query and stored procedure ?

Question Posted / tmp

15 Answers
77444 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

Please Help Members By Posting Answers For Below Questions

Explain acid?

1137

Do you think BCNF is better than 2NF & 3NF? Why?

1338

Explain DBCC?

1009

what is create database syntax? : Sql server database administration

1154

What are the general features of sql server management studio? : sql server management studio

1126

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1122

What is mapping schema?

1065

What do you understand by physical_only option in dbcc checkdb?

1020

What is the difference between sdf and mdf?

1349

Explain the concept of recursive stored procedure.

1019

What is the ‘fillfactor’?

1013

What is the stuff and how does it differ from the replace function?

1219

What is encryption key?

137

What is the standby server?

998

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

991