Create Trigger Tr_process on table for insert as SET IDENTITY_INSERT 表 ON ....................
CREATE TRIGGER Ret ON [dbo].[fgong_jdu_Bak] FOR DELETE ASSET NOCOUNT ON SET IDENTITY_INSERT fgong_jdu ONInsert fgong_jdu Select * From deleted ------------------------------------------------- fgong_jdu_Bak的结构和fgong_jdu的结构一样 fgong_jdu 有个标识列
Insert fgong_jdu Select * From deleted改为: Insert fgong_jdu(写上字段列表) Select * From deleted--我想错误提示一定有提示楼主这样做的,只不过楼主忽略了.
for insert
as
SET IDENTITY_INSERT 表 ON
....................
FOR DELETE
ASSET NOCOUNT ON
SET IDENTITY_INSERT fgong_jdu ONInsert fgong_jdu Select * From deleted
-------------------------------------------------
fgong_jdu_Bak的结构和fgong_jdu的结构一样
fgong_jdu 有个标识列
Insert fgong_jdu(写上字段列表) Select * From deleted--我想错误提示一定有提示楼主这样做的,只不过楼主忽略了.