Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76949 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
Can we perform backup restore operation on tempdb? : sql server database administration
What is the impact on other user sessions when creating indexes?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Do you know what is sql service broker?
What is 4nf in normalization form?
What is the difference between for auto and for nested?
Which is better statement or preparedstatement?
What is left outer join in sql server joins?
Can you move the resources after pausing the node? : sql server database administration
What are the key configuration files for sql server reporting services ?
Explain different types of collation sensitivity?
What is the benefit of normalization?
What are the components of sql server service broker?
What are the different kinds of ssrs reports?
Which sql server table is used to hold the stored procedure scripts?
