不能行级触发,但如果你需要将影响的数据放到一个表的话,可以用类似类似的触发器:create trigger t_test on 表
for insert,update,delete
as
insert into 保存影响行的表 select * from inserted
insert into 保存影响行的表 select * from deleted
go
for insert,update,delete
as
insert into 保存影响行的表 select * from inserted
insert into 保存影响行的表 select * from deleted
go
FOR INSERT
AS
insert db2..tabSlave select * from inserted
goCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
goCREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
go或在触发器里使用游标:
declare cursor_insert cursor for select 列 from inserted
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
.........
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
create trigger 就ok啦ok?
看样子,你不懂SQL Server哈。