Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajnidas
Yak Posting Veteran
97 Posts |
 Posted - 2013-10-23 : 01:50:42
|
| hi , i am new in sql progaramming , i need coding help , i want know what is trigger and what actually it do and give any example , i wiil try to execute in my system .thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-23 : 01:58:11
|
| Trigger is a special type of procedure code that gets executed based on an event. There are DDL,DML and LOGON triggers. DDL triggers gets executed in response to a DDL event (CREATE, ALTER, DROP). DML triggers executes in response to DML activities on table (INSERT, UPDATE, DELETE). They can also be executed before or after the event (AFTER and INSTEAD OF).For example seehttp://technet.microsoft.com/en-us/library/ms189799.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
|
|
rajnidas
Yak Posting Veteran
97 Posts |
Posted - 2013-10-23 : 02:21:05
|
| thank u so much for reply |
|
|
|
|
|
|
trigger