Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71633 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / gayathri
Every query is submited it will be compiled & then
executed.where as stored procedure is compiled
when it is submitted for the first time and this compiled
content is stored in something called procedure cache,
for subsequent calls no compilation,just execution & hence
better performance than query.
In Query we can execute only 1 statement. Stored Procedure:
In Stored Procedure we can execute Batch of Queries
| Is This Answer Correct ? | 103 Yes | 11 No |
Post New Answer View All Answers
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is transaction server explicit transaction?
What is the name of reporting services config file and what’s it’s used for?
Explain candidate key, alternate key, and composite key?
What the different components in replication and what is their use?
What is sql server programming?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What is difference between inner join and full join?
User wants only to display only pdf as export option in report manager. How to achieve this?
How use inner join in sql server?
Explain about system stored procedure?
How do I view a procedure in sql server?
Does table partitioning improve performance?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Explain difference between cross join and full outer join?
