求一触发器写法，触发多条插入

[chengfeng]

当a(字段：ID，...)表插入一条记录时
触发b表插入多条记录(字段：ID，xh)
b.ID=a.ID, xh从1-20

[YaoMing_csdn]

create trigger t_MyTrigger
on a
after insert
as
begin
declare @xh int
declare @sql varchar(4000)
declare @id int

select @id = [ID] from inserted

set @xh=1
while (@xh<=20)
begin
set @sql='insert into b values('+@id+','+@xh+')'
exec @sql
set @xh=@xh+1
end
end

[YaoMing_csdn]

I am not sure this script will work. But this is a way you should to think.

This script will not work correct if you insert multi rows to table a.

[rea1gz]

create trigger tr_a_insert
on a
for insert
as
insert b (id,xh)
select i.id,t.xh
from insert i,(
select 1 as xh
union all select 2
union all select 3
union all select 4
union all select 5
union all select 6
union all select 7
union all select 8
union all select 9
union all select 10
union all select 11
union all select 12
union all select 13
union all select 14
union all select 15
union all select 16
union all select 17
union all select 18
union all select 19
union all select 20
) as t

go

[rea1gz]

1楼的代码有个大问题，如果一次插入多条记录，这个触发器不正常，只插入一个id的20条记录到b表

[Well]

create trigger InsertMoreData
on a
for insert
as
insert into b
select * from a where id<=20
go

[YaoMing_csdn]

To rea1gz: I have prompted it on 2nd floor.

[rea1gz]

呵呵，看英文比较累