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


Please Help Members By Posting Answers For Below Questions

What is rtm version in sql server?

750


What are parameterized reports?

178


Why use sub query in sql server and list out types of sub queries?

769


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

932


What are the types of database schema? : sql server analysis services, ssas

825


Explain the steps to create and execute a user-defined function in the sql server?

753


What happens if you insert a duplicate key for the primary key column in ms sql server?

772


Explain what is log shipping?

872


Define ACID properties in a Database?

858


Explain “row_number()” in sql server with an example?

777


What area unit the various kinds of info compression introduced in sql server 2008?

802


How do I shrink an ldf file?

774


Can I use sql azure as a backup with log shipping or database mirroring?

148


How to delete an existing database user?

793


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

966