Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 77454 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
What does dml stand for?
What is difference between delete and truncate commands?
Can you use order by when defining a view?
What is tablix?
what purpose does the model database serve? : Sql server database administration
What are the differences between decimal and float in ms sql server?
Can you explain what are commit and rollback in sql?
What are data driven subscriptions?
What is difference between temp table and cte?
What is sql collation?
What is forward - only cursors / read only cursor?
What are magic tables in sql server?
What happens if time-only values are provided as date and time literals?
Write a sql query to get zero records from a table having n number of records?
How can you know if the row fetched from cursor is still valid in underlying table?
