Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73453 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / gangi naidu.k
In case of sql queries,it is possible to compile one query
at a time,but incase of stored procedure we can compile
bunch of queries at a time and also it is need at first
time only,suppose we need modification on queries,after
modifications no need to compile again in case of stored
procedures,but in case of sql queries we have to compile
every time.Stored procedure contain queries in compiled
format so execution also fast and tome saving.One more
thing is in case of stored procedures serurity also more.
| Is This Answer Correct ? | 18 Yes | 15 No |
Post New Answer View All Answers
What is the difference between seek predicate and predicate?
When do you think a developer should use sql server-based cursors?
What are the disadvantages of primary key and foreign key in SQL?
What is update locks?
What are the different types of stored procedures?
What is sql server programming?
What is use of except clause?
What is sql service broker?
Explain what is the purpose of sql profiler in sql server?
How many non clustered indexes there can be on table ?
In case you have filters in your report, when filters will be applied in cached report instance?
Can you explain about buffer cash and log cache in sql server?
What are the limitations/drawbacks or ssrs 2008 r2?
What is the default port for SQL Server over a firewall?
What is pivot and unpivot?
