Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76223 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
How to change the data type of an existing column with "alter table" statements in ms sql server?
What are subqueries in sql server?
What is normalization process?
Why we use the openxml clause?
What are sql server procedures?
How to install sql server 2005 express edition?
How secure is sql server database?
What is the Main Difference between ACCESS and SQL SERVER?
can a database be shrunk with users active? : Sql server administration
How to invoke a trigger on demand?
Which database stores information about replication?
What is raid? : SQL Server Architecture
What do you mean by stored techniques? How would we use it?
What are information schema views?
What is extent? Types of extents?
