Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71661 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
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Tell me what are the essential components of sql server service broker?
How to concatenate two strings in SQL Server.
Define msdb database?
What is the difference between stored procedure and user defined functions?
What is create command?
What are the differences between left join and inner join in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How to get a list of all tables with "sys.tables" view in ms sql server?
How do you create an execution plan?
What is attribute? : sql server analysis services, ssas
What does REVERT do in SQL Server 2005?
What is left outer join in sql server joins?
What are different types of raid levels?
