<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
SELECT*FROM deletedCREATETRIGGERTR_LKCRM_SQJBXXINS
ONdbo.LKCRM_SQSP_SQJBXX
FORINSERT
AS
BEGIN
DECLARECUR_LKCRM_SQJBXXINSCURSORFORSELECTINS.SQXH,INS.DYXH,INS.SQLBFROM inserted INS
DECLARE@SQXHINT
DECLARE@DYXHINT
DECLARE@SQLBNVARCHAR(2)
OPENCUR_LKCRM_SQJBXXINS
FETCHNEXTFROMCUR_LKCRM_SQJBXXINSINTO@SQXH,@DYXH,@SQLB
WHILE@@FETCH_STATUS=0
BEGIN
IF@SQLB='01'OR@SQLB='04'
UPDATELKCRM_DD_DDXXSETSPTGBZ='0'WHEREDDXH=@DYXH
ELSE
BEGIN
IF@SQLB='02'
UPDATELKCRM_DD_THDXXSETSPTGBZ='0'WHERETHDXH=@DYXH
ELSE
BEGIN
IF@SQLB='03'
UPDATELKCRM_SC_SCHDJLSETSPTGBZ='0'WHEREHDXH=@DYXH
END
END
FETCHNEXTFROMCUR_LKCRM_SQJBXXINSINTO@SQXH,@DYXH,@SQLB
END
CLOSECUR_LKCRM_SQJBXXINSDEALLOCATECUR_LKCRM_SQJBXXINS
END
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
deleted和
inserted
是逻辑(
概念)表。这些表在结构上类似于定义触发器的表(也就是在其中尝试用户操作的表);这些表用于保存用户操作可能更改的行的旧值或新值。例如,若要检索
deleted表中的所有值,请使用:
SELECT*FROM deletedCREATETRIGGERTR_LKCRM_SQJBXXINS
ONdbo.LKCRM_SQSP_SQJBXX
FORINSERT
AS
BEGIN
DECLARECUR_LKCRM_SQJBXXINSCURSORFORSELECTINS.SQXH,INS.DYXH,INS.SQLBFROM inserted INS
DECLARE@SQXHINT
DECLARE@DYXHINT
DECLARE@SQLBNVARCHAR(2)
OPENCUR_LKCRM_SQJBXXINS
FETCHNEXTFROMCUR_LKCRM_SQJBXXINSINTO@SQXH,@DYXH,@SQLB
WHILE@@FETCH_STATUS=0
BEGIN
IF@SQLB='01'OR@SQLB='04'
UPDATELKCRM_DD_DDXXSETSPTGBZ='0'WHEREDDXH=@DYXH
ELSE
BEGIN
IF@SQLB='02'
UPDATELKCRM_DD_THDXXSETSPTGBZ='0'WHERETHDXH=@DYXH
ELSE
BEGIN
IF@SQLB='03'
UPDATELKCRM_SC_SCHDJLSETSPTGBZ='0'WHEREHDXH=@DYXH
END
END
FETCHNEXTFROMCUR_LKCRM_SQJBXXINSINTO@SQXH,@DYXH,@SQLB
END
CLOSECUR_LKCRM_SQJBXXINSDEALLOCATECUR_LKCRM_SQJBXXINS
END
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>