在表触发器中打开它是可能的吗?
我尝试创建一个带有SET IDENTITY_INSERT tableName ON语句的触发器。
但是当我打开触发器定义时,我发现这个语句不在那里...
这是我用来更改触发器以添加IDENTITY_INSERT的查询,但是当我打开定义时,IDENTITY_INSERT被删除了...
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET IDENTITY_INSERT dbo.MyTable ON
GO
ALTER TRIGGER [dbo].[MyTrigger]
ON [dbo].[MyTable]
AFTER INSERT AS
INSERT INTO MyOtherTable
(
// values
)
SET IDENTITY_INSERT dbo.MyTable OFF