SQL笔记：限制条码和删除标记为0的记录唯一

set  ANSI_NULLS  ON
set  QUOTED_IDENTIFIER  ON
go

-- 限制条码和删除标记为0的记录唯一
-- Commit Date:11:00 2006-9-22
ALTER   TRIGGER   [ TR_IU_OutByMachineDetail ]  
    ON   [ dbo ] . [ T_OutByMachineDetail ]   
   AFTER  INSERT ,  UPDATE
AS  
BEGIN
     DECLARE   @rowCount      INT
     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

转载于:https://www.cnblogs.com/pingkeke/archive/2006/09/22/511824.html