Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76201 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
List some of the rules that apply to creating and using a ‘view’
Do you know what is normalization of database? What are its benefits?
What is the difference between lock, block and deadlock? : sql server database administration
What does indexation mean?
What command must you use to include the not null constraint after a table has already been created?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Which language rdl files made of?
When would you use the stored procedures or functions?
what is the primary use of the model database? : Sql server administration
What does set rowcount do?
What are two difference between sql azure and azure tables?
how can u get last observation in an unknown dataset ?
Do you know what is a linked server in sql server?
Do you know what are different types of replication in sql server?
Write a SQL query to delete a table?
