禁用为表启用触发器 SQL 服务器
我想创建一个像下面这样的过程,但它有语法错误.有人能指出问题吗?
I want to create one proc like below but it has error on syntax. Could anyone pointing out the problem?
Create PROCEDURE [dbo].[my_proc] AS
BEGIN
DISABLE TRIGGER dbo.tr_name ON dbo.table_name
-- some update statement
ENABLE TRIGGER dbo.tr_name ON dbo.table_name
END
** Error Message : Incorrect syntax near 'ENABLE'.
推荐答案
改用以下命令:
ALTER TABLE table_name DISABLE TRIGGER tr_name
ALTER TABLE table_name ENABLE TRIGGER tr_name
相关文章