急。。关于用trigger有条件复制表！！

[rhesus]

比如：
表table1
ID name class score
1 z 1 23
2 s 1 54
3 a 2 56
4 h 5 67

表table2
用trigger语句能把寄数的记录insert到table2中吗？

[renmao]

可以的呀，不过你要控制它才是的！

[hjhing]

create trigger yourTrigger
on table1 for insert,update
as

insert into table2
select * from inserted
where [ID] mod 2 =1

update table2
set name= A.name,class=A.class,score=A.score
from updated A
where [ID]=A.ID