试一试这个,如果好的话,请通知一下 alter table table_name disable trigger trigger_name ,alter table table_name enable trigger trigger_name to switch back on. leave out the trigger name and applies to all triggers for trigger_name. (in 12.0.)
当然有,例: create trigger triname on tabname for update as select.... 如果屏蔽该触发器:alter table tabname disable trigger triname 如果激活该触发器:alter table tabname enable trigger trinameSqlServer 70运行通过
在程序中得到的条件不能传到触发器里,怎么用if?
begin
return ---- add
....
....end
怎么知道什么时候要加return?
Trigger只是一类特殊的Stored Procedure,在insert、update、delete时自动触发,但不能传入传出参数。问题好象很高难啊!
你说中我的意思了。
因为我要在程序中做几个表的数据搬迁,但此时不需要触动触发器。难道真的没有办法了吗,有没有象oldwain(老斗)在oracle中的
alter trigger <trigname> disable;
..
..
表搬迁语句.
..
..
Enable trigger xxx
..
数据搬迁
..
enable trigger xxname
sql server 的 t_sql 语法好象没有这样的写法吧.
alter table table_name disable trigger trigger_name ,alter table table_name enable trigger trigger_name to switch back on. leave out the trigger name and applies to all triggers for trigger_name. (in 12.0.)
create trigger triname
on tabname
for update
as
select....
如果屏蔽该触发器:alter table tabname disable trigger triname
如果激活该触发器:alter table tabname enable trigger trinameSqlServer 70运行通过