Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71847 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / ashwini
SQL query will be compiled everytime it is executed.
Stored procedures are compiled only once when they are
executed for the first time.
| Is This Answer Correct ? | 209 Yes | 18 No |
Post New Answer View All Answers
your distribution database is full what will u do
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is raid? : SQL Server Architecture
What is the fastest way to permanently delete a 1 million row table named customers?
Explain the steps needed to create a scheduled job?
Explain different backup plans?
Explain can SSRS reports Cache results?
What is the boxing and unboxing concept in .net?
What is check constraint in sql server?
What happens if ntwdblib.dll is missing on your machine?
What are the properties of the transaction?
Write a SQL query to delete a table?
How to get the definition of a trigger back?
What is the difference between createstatement and preparedstatement?
What is indexing and its types?
