set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go --限制条码和删除标记为0的记录唯一 --Commit Date:11:00 2006-9-22 ALTERTRIGGER[TR_IU_OutByMachineDetail] ON[dbo].[T_OutByMachineDetail] AFTER INSERT, UPDATE AS BEGIN DECLARE@rowCountINT SELECT@rowCount=COUNT(V_BarCode) FROM T_OutByMachineDetail WHERE V_BarCode IN (SELECT V_BarCode FROM INSERTED WHERE IsDeleted =0) IF (@rowCount>0) ROLLBACK END
posted on
2006-09-22 14:27记得忘记
阅读(262)
评论(0)
编辑收藏举报