Trigger: trg_ins_t1 Trigger: trg_ins_t1| Property | Value |
|---|---|
| Trigger | trg_ins_t1 |
| ID | 1335675806 |
| Owner | dbo |
| Schema | dbo |
| For Object | t1 |
| Disabled |
|
| Is Not For Replication |
|
| Trigger Type Description | SQL TRIGGER |
| ANSI NULLS |
|
| QUOTED IDENTIFIER |
|
| Encrypted |
|
| MS Shipped |
|
| Execute As | Caller |
| Modify Date | 4/24/2011 4:07:42 PM |
| Creation Date | 4/24/2011 4:04:47 PM |
| Is After Trigger | Is Instead Of | Insert Trigger | Update Trigger | Delete Trigger |
|---|---|---|---|---|
|
|
|
|
|
|
| First Delete Trigger | First Insert Trigger | First Update Trigger | Last Delete Trigger | Last Insert Trigger | Last Update Trigger |
|---|---|---|---|---|---|
|
|
|
|
|
|
|
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE trigger trg_ins_t1 on t1 for insert as begin declare @c1 int declare @c2 int select @c1 = c1, @c2 = c2 from inserted print @c1 print @c2 select * from inserted end |