create trigger trg_test on table1 for insert as declare @field1 varchar(10) declare cur_test cursor for select field1 from inserted open cur_test fetch next from cur_test into @field1 while @@fetch_status=0 begin insert into table2(field1) values(@field1) fetch next from cur_test into @filed1 end close cur_test或者 create trigger trg_test on table1 for insert as insert into table2(field1) select field1 from inserted应该都可以,而且可以保证同时插入多条时也能正确
on table1
for insert
as
declare @field1 varchar(10)
declare cur_test cursor
for select field1 from inserted
open cur_test
fetch next from cur_test
into @field1
while @@fetch_status=0
begin
insert into table2(field1) values(@field1)
fetch next from cur_test
into @filed1
end
close cur_test或者
create trigger trg_test
on table1
for insert
as
insert into table2(field1) select field1 from inserted应该都可以,而且可以保证同时插入多条时也能正确