Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71806 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / gayathri
Every query is submited it will be compiled & then
executed.where as stored procedure is compiled
when it is submitted for the first time and this compiled
content is stored in something called procedure cache,
for subsequent calls no compilation,just execution & hence
better performance than query.
In Query we can execute only 1 statement. Stored Procedure:
In Stored Procedure we can execute Batch of Queries
| Is This Answer Correct ? | 103 Yes | 11 No |
Post New Answer View All Answers
What is dimension table? : sql server analysis services, ssas
Explain different forms of normalization?
What are various limitations of the views?
Can I work with several databases simultaneously? : sql server management studio
What are points to remember while using the fillfactor argument?
What is a cube? : sql server analysis services, ssas
What is difference between view and materialized view?
How important do you consider cursors or while loops for a transactional database?
what are the different types of replication you can set up in sql server? : Sql server database administration
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Explain Geometry datatype in sql server 2008 with example
Explain some stored procedure creating best practices or guidelines?
What are “unrepeatable reads”?
Explain the steps to use transact-sql cursor?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
