Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73648 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 are the recovery models for a database?
Explain different backup plans?
What are the types of lock supported by ?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What are the different types of join?
What are the steps you will take to improve the performance of a poor performing query?
How to override dml statements with triggers?
Why do we partition data?
Sql server reporting services vs. Crystal reports.
What is a Join and explain its types?
Determine when to use stored procedure to complete sql server tasks?
Which are new data types introduced in sql server 2008?
Write a SQL query to make a column as unique?
What are the disadvantages of primary key and foreign key in SQL?
What is the difference between functions and scalar functions?
