Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71805 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
How to select some specific columns from a table in a query in ms sql server?
Explain full-text indexing?
What are the joins in sql server? : sql server database administration
Do you think BCNF is better than 2NF & 3NF? Why?
Explain having clause and where clause?
What is an identity column in insert statements?
What are the disadvantages of merge replication?
How much does sql server 2016 cost?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is an index. What are the types?
What is difference between rownum and row_number?
What are the operating modes in which database mirroring runs?
What is the fillfactor concept in indexes?
Explain go command in sql server?
Explain hostprotectionattribute in sql server 2005?
