Trigger

Question

Please send me Trigger Examples and How to use in my Applications. Thanks&Reg Magesh.A

Dipal Choksi · Answer

Typical uses of triggers would be updating related records to maintain referential integrity or writing an audit log. You can set up your custom logic within the triggers to respond to the corresponding database events.

Senthilkumar · Answer

Hi Trigger is a database event it will be automatically fired when database events happens like DML DDL in the database. There are several types of triggers in sql server. - DMLtrigger - DDL trigger -Loggon Trigger You can get more infomation on: http://msdn.microsoft.com/en-us/library/ms189799.aspx http://www.go4expert.com/forums/showthread.php?t=15510

Jignesh Trivedi · Answer

hi A trigger is a database object that is attached to a table. In many aspects it is similar to a stored procedure. In other word trigger is special kind of stored procedure. please refer http://www.go4expert.com/forums/showthread.php?t=15510 for how to create trigger. hope this help.