我写了一个更新记录的代码，它工作正常，但我还需要检查重复 [英] I Wrote a Code TO Update A Record ,It's Working Fine But I Need To Check The Dupilications Also

问题描述

BEGIN
 IF(@intDesignationId>0)
  BEGIN
IF EXISTS(SELECT 1 FROM dbo.tabDesignation WHERE  intDesignationId= @intDesignationId ) --AND  intBranchId=@intBranchId  )

    BEGIN
  
    UPDATE dbo.tabDesignation

     SET intcadreid =@intcadreid ,
    intDepartmentid =@intDepartmentid ,
    varDesignationName=@varDesignationName,
    varDesignationShortName=@varDesignationShortName,
    intRetirementAge=@intRetirementAge,
    varRemarks=@varRemarks,
    varOfferLetterType=@varOfferLetterType
    WHERE  intDesignationId=@intDesignationId
     
 RETURN 0
 end


  ELSE
 RETURN 1


  END

推荐答案

要检查重复项，您只需检查是否存在此类记录。如果存在Where条件

To check duplicates, you can simply check whether such record exists. Use if exists with Where condition

这篇关于我写了一个更新记录的代码，它工作正常，但我还需要检查重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！