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 is rtm version in sql server?
What are parameterized reports?
Why use sub query in sql server and list out types of sub queries?
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?
What are the types of database schema? : sql server analysis services, ssas
Explain the steps to create and execute a user-defined function in the sql server?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Explain what is log shipping?
Define ACID properties in a Database?
Explain “row_number()” in sql server with an example?
What area unit the various kinds of info compression introduced in sql server 2008?
How do I shrink an ldf file?
Can I use sql azure as a backup with log shipping or database mirroring?
How to delete an existing database user?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication