Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71779 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 is sql or structured query language?
Explain an incremental backup?
Do you know what is blocking?
What methods do you follow to protect from sql injection attack?
Difference between Inner vs outer joins?
What is the difference between nvl and nvl2?
Explain unique key in sql server?
Explain about Normalization?
What is dbcc? Give few examples.
How to create an inline table-valued function?
Are resultset updatable?
What are Row versions of DataRow?
What is left outer join in sql server joins?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
