下面是我测试用的
table1 (临时表)
id char key
aa char
bb char
cc char
tt bit
table2
id char key
aa char
bb char
cc char
触发器这么写的。不知道对不对~大家帮我看看
CREATE TRIGGER try ON dbo.Table1
FOR UPDATE
AS
IF Update (tt)
Begin
Declare @vBit Bit
Select @vBit=tt From Deleted
If @vBit=1
Begin
Insert Table2 Select id,aa,bb,cc From Table1
Delete Table1
End
End