Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76821 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
Give an example of SQL injection attack ?
What are views in ms sql server?
what happens on checkpoint? : Sql server database administration
What is the need for group functions in sql?
How do you debug a procedure in sql server?
What happens if you are trying to access a schema not owned by you?
What are the instances when triggers are appropriate?
Why we use the openxml clause?
What new changes are being made in SQL Server?
When you should use a low fill factor?
How to truncate the log in sql server 2012? : sql server database administration
Do you know hot add cpu in sql server 2008?
What are the advantages to use stored procedures?
What is the parse query button used for?
What is nonclustered index with included columns ?
