Difference between Triggers and Stored Procedure
Answer Posted / shilpa
triggers are fired automatically when any event ocours like
update ,delete ,insert on a table
whereas sp is set of sql statements its not related to
single table but its can have many sql satements that can
be used in many tables to update, delete and insert .
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are the different Authentication modes in SQL Server and how can you change authentication mode?
what happens on checkpoint? : Sql server database administration
How many types of database relationship in sql server?
What is inner join in sql server joins?
How many triggers you can have on a table?
What are 3 ways to get a count of the number of records in a table?
What is the difference between clustered index and primary key?
How to use clusters?
How do triggers work?
What are the difference between clustered and a non-clustered index?
Why use view instead of a table?
How can you check the version of sql server?
Does index slows down insert statements?
When cursors are useful?
What is difference between view and materialized view?