Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71837 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / robinson
The execution plan will be created when compiling the stored
procedure and permanently stored in the database and so it
is much efficient, But in the case of query the execution
plan will be created at runtime.
| Is This Answer Correct ? | 30 Yes | 9 No |
Post New Answer View All Answers
What is entity data services?
What is the boxing and unboxing concept in .net?
what is isolation level at dead lock?
What is difference between equi join and natural join?
What encryption security is available in sql azure?
What is ms sql server reporting services?
What is difference between unique and primary key?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How do I open a .db file?
What is the New in SQL server 2008?
Can we write trigger for view?
What are translations and its use? : sql server analysis services, ssas
How to start and end transact-sql statements?
How sql server executes a statement with nested subqueries?
How to verify a login name with sqlcmd tool?
