Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71794 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / swathi
Queries are compiled each and evey time when we execute.
where as Stored Procedures are compiled only once when we
execute for the first time and the execution plans are
cached in memory.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
what is raid and what are different types of raid configurations? : Sql server database administration
What is a not null constraint?
What protocol does sql server use?
Write a SQL query in order to merge two different columns into single column?
What are cursors stored procedures and triggers?
What are views in ms sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
What is logon trigger?
What is the purpose of data source?
Explain about thread and memory management process of SQL?
What is the importance of concurrency control?
What is a heap?
What is sql language?
What is the security model used in sql server 2005?
Do you know what are the restrictions that views have to follow?
