CREATE TRIGGER [TRIGGER NAME] ON A
FOR INSERT
AS
insert into B as insertedCREATE TRIGGER [TRIGGER NAME] ON A
FOR UPDATE
AS
insert into B as updated
FOR INSERT
AS
insert into B as insertedCREATE TRIGGER [TRIGGER NAME] ON A
FOR UPDATE
AS
insert into B as updated
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS
[ { IF UPDATE ( column )
[ { AND | OR } UPDATE ( column ) ]
[ ...n ]
| IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask )
{ comparison_operator } column_bitmask [ ...n ]
} ]
sql_statement [ ...n ]
}
} 注意那有IF UPDATE ( column )
FOR INSERT
AS
insert B select * from insertedCREATE TRIGGER trig_a_update ON A
FOR UPDATE
AS
if update(f1) or update(f2) or update(f3) or update(f4)
insert b select * from inserted