Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71932 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / swathi
Queries are compiled each and evey time when we execute.
where as Stored Procedures are compiled only once when we
execute for the first time and the execution plans are
cached in memory.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is 3nf normalization?
What is user defined datatypes and when you should go for them?
Name some of the open source software that you can use in alternative to SSR?
Why Master database is required?
Explain what is lock escalation and what is its purpose?
Detail about query optimizer?
How do I find my localdb version?
What is triggers and its types?
What are acid properties of transaction?
What are user defined functions in ms sql server?
What the different components in replication and what is their use?
What is difference in performance between insert top (n) into table and using top with insert?
What is self contained scalar sub query?
on line cluster can we make if yes tell me the procedure
