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