Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 77464 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 a schema in sql server 2005? : Sql server database administration
What is the exact numeric data type in sql?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
Why would you use sql agent?
What’s the use of custom fields in report?
What is the filtered index?
Does table partitioning improve performance?
What are commonly used mssql functions in php?
What is the default Port No on which SQL Server listens?
Explain different types of Normalization.
Explain the phases a transaction has to undergo?
What is exporting and importing utility?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Explain the concept of recursive stored procedure.
Write a query for primary key constraint with identity key word?
