虚心求教各位

[668]

我现有以下T1 和 T2 两张表
T1
a !
b !
c
d
T2
aa !
bb !
cc
我写了个触发器如下,目的是要做到当向T1表插入数据时同时取出inserted表中的a,b两个列插入到T2表(a,b,aa,bb都是主键)
CREATE TRIGGER Trigger_T1 ON T1
FOR INSERT
as
insert into T2 select a,b from inserted
go
但是数据库报错说少一个列,不过的确少一个cc列的数据,但我又不知道从哪搞来一个列向cc列插入,能插入空数据也可以,请指点.

[dafu71]

CREATE TRIGGER Trigger_T1 ON T1
FOR INSERT
as
insert into T2 select a,b,'' from inserted
go

[txlicenhe]

依C的数据类型选用如下语句：
insert into T2 select a,b,'' from inserted
或
insert into T2 select a,b,NULL from inserted
或
insert into T2 select a,b,0 from inserted

[txlicenhe]

或指定字段名也可
insert into T2(a,b) select a,b from inserted
go

[yujohny]

CREATE TRIGGER Trigger_T1 ON T1
FOR INSERT
as
insert into T2(aa,bb) select a,b from inserted
go

[zezejun]

CREATE TRIGGER Trigger_T1 ON T1
FOR INSERT
as
insert into T2(aa,bb) select a,b from inserted
go

[wzh1215]

CREATE TRIGGER Trigger_T1 ON T1
FOR INSERT
as
insert into T2(aa,bb) select a,b from inserted
go
--此时的条件是T2表的cc字段必须允许为空！