Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 77470 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
Why normalization is used?
Explain how many types of relationship?
Define union, union all, minus, intersect?
Difference between report and query parameter.
What is stored procedures?
What is the difference between grant and with grant while giving permissions to the user?
What will happen if a column containing char type data is changed to the nchar data type?
What are dml triggers and types of dml triggers?
Explain user defined functions?
Do you know concepts and capabilities of sql server?
How to delete a database in ms sql server?
What are the differences between web role and worker role?
What happens when transaction log is full?
What is use of except clause? How does it differ from not in clause?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
