Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71659 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / kshitij s. nirmaley
query and stored procedure do the same thing but the
difference is that a query should be compiled every time the
query is executed, while the stored procedure is in compiled
form when executed first time .If we use stored procedure
we can avoid recompilation of the query.
| Is This Answer Correct ? | 23 Yes | 5 No |
Post New Answer View All Answers
Why do we use functions?
List out some of the requirements to set up a sql server failover cluster?
What's the information that can be stored inside a bit column?
How you can minimize the deadlock situation?
Ms sql server index?
What is a join in sql? What are the types of joins?
What is log shipping?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How do I find the sql server database version?
How to delete duplicate records based on single column from a table?
Why would you use sql agent?
Why use update_statistics command in sql server?
What are constraints in microsoft sql server?
Can we use custom code in ssrs?
What is acid db?
