deleted 和 inserted 是逻辑（概念）表。

deleted 和 inserted 是逻辑（概念）表。

deleted 和 inserted 是逻辑（概念）表。 deleted 和 inserted 是逻辑（概念）表。这些表在结构上类似于定义触发器的表（也就是在其中尝试用户操作的表）；这些表用于保存用户操作可能更改的行的旧值或新值。例如，若要检索 deleted 表中的所有值，请使用： SELECT *FROM deletedCREATE TRIGGER TR_LKCRM_SQJBXXINS

ON dbo.LKCRM_SQSP_SQJBXX

FOR INSERT

AS

BEGIN

DECLARE CUR_LKCRM_SQJBXXINS CURSOR FOR SELECT INS.SQXH,INS.DYXH,INS.SQLB FROM INSERTED INS

DECLARE @SQXH INT

DECLARE @DYXH INT

DECLARE @SQLB NVARCHAR(2)

OPEN CUR_LKCRM_SQJBXXINS

FETCH NEXT FROM CUR_LKCRM_SQJBXXINS INTO @SQXH,@DYXH,@SQLB

WHILE @@FETCH_STATUS = 0

BEGIN

IF @SQLB='01' OR @SQLB='04'

UPDATE LKCRM_DD_DDXX SET SPTGBZ='0' WHERE DDXH=@DYXH

ELSE

BEGIN

IF @SQLB='02'

UPDATE LKCRM_DD_THDXX SET SPTGBZ='0' WHERE THDXH=@DYXH

ELSE

BEGIN

IF @SQLB='03'

UPDATE LKCRM_SC_SCHDJL SET SPTGBZ='0' WHERE HDXH=@DYXH

END

END

FETCH NEXT FROM CUR_LKCRM_SQJBXXINS INTO @SQXH,@DYXH,@SQLB

END

CLOSE CUR_LKCRM_SQJBXXINS DEALLOCATE CUR_LKCRM_SQJBXXINS

END