Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76992 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 throw custom exception in Stored Procedure?
What is difference between clustered and non clustered index?
How to see existing views in ms sql server?
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.
How to loop through returning rows?
How to change server name in sql server?
How do I find the default sql server instance?
Why would you call update statistics?
How to send email from database?
How do we know if any query is retrieving a large amount of data or very little data?
How to write a query with a full outer join in ms sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What to perform pattern match with the like operator?
What is the new security features added in sql server 2016? : sql server security
What is a constant or literal in ms sql server?
