触发器的大问题,请各位高手支招:
在MS SQL Server中 trigger的for类型不支持text、ntext、image字段,使用instead of就可以了,可是对当前表的操作也cancel了,于是我使用了
insert into table select * from inserted,整个trigger如下:
create trigger uptTest
on Test
instead of update
begin
....
delete from Test where id in (select id from deleted)
insert into Test select * from inserted
end
这样势必形成trigger的直接递规,于是我采用了如下方式:
create trigger uptTest
on Test
instead of update
begin
....
alter table Test disable trigger all
delete from Test where id in (select id from deleted)
insert into Test select * from inserted
alter table Test enable trigger all
end
可又引发新的问题,我用程序处理Test表时,只能一行一行的处理,没法处理多行.多行一起处理时,引发"表结构已更改,游标失效"的错误。
各位高手支支招,我急用!