Please send me Trigger Examples and How to use in my Applications.
Thanks&Reg
Magesh.A
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Dipal ChoksiPosted Mar 26, 2012, 2:59 AM
You can set up your custom logic within the triggers to respond to the corresponding database events.
SenthilkumarPosted Mar 26, 2012, 2:50 AM
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 TrivediPosted Mar 26, 2012, 2:16 AM
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.