Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71773 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 difference between views and tables?
How to create a simple table to test triggers in ms sql server?
Which are the third-party tools used in sql server and why would you use them?
How to create sub reports?
Explain how many normalization forms?
Explain indexed views?
How can I get data from a database on another server?
How to resolve the orphan use problem? : sql server security
How to add additional conditions in SQL?
Is sql server implemented as a service or an application? : Sql server database administration
What are exact numeric data types in ms sql server?
What are the steps you can take to avoid “deadlocks”?
What is auditing in sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to loop through result set objects using odbc_fetch_row()?
