11,849
社区成员
发帖
与我相关
我的任务
分享
好象是直接删除触发器
create trigger f_del on master..tb
for delete
as
drop trigger try2009a..tb.try_insdelupd
CREATE TRIGGER TRI_DELETE ON MASTER..TB
FOR DELETE
AS
DROP TRIGGER TRY2009A..TB.TRY_INSDELUPD
DECLARE @ls_sql VARCHAR(8000)
SELECT @ls_sql='use try2009a
drop trigger try_insdelupd'
exec (@ls_sql)
DECLARE @ls_sql VARCHAR(8000)
SELECT @ls_sql='use try2009a
drop trigger tb.try_insdelupd'
exec (@ls_sql)