Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76226 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 merge?
Can a table have 2 primary keys?
What is the difference between an index and a unique index?
Explain the categories of stored procedure?
What are synonyms?
Is it ok to shrink transaction log?
What is in place upgrade in sql server?
What are the advantages of sql azure?
what kind of lan types do you know? : Sql server database administration
What is the difference between a unique key and primary key?
What are triggers? How do you invoke a trigger on demand?
What are drilldown reports?
Explain how would you store your query in an SSRS report or a Database server?
What is key set driven?
What is the difference between ddl and dml?
