I'm working on my first update trigger.

An SP that operates on the column I'm monitoring for update includes this fragment

UPDATE dbo.PATIENT_CLAIM_837_2000C
SET Claim_Status = '00'
WHERE Claim_Seq_No = @iClaimSeqNo 
      AND @iClaimPayersCount = @iMatchedPayersCount

Is there any reason THAT form is preferable to:

IF @iClaimPayersCount = @iMatchedPayersCount
    UPDATE dbo.PATIENT_CLAIM_837_2000C
    SET Claim_Status = '00'
    WHERE Claim_Seq_No = @iClaimSeqNo 
      

The second form seems more efficient, and it does not fire the trigger if

@iClaimPayersCount <> @iMatchedPayersCount

The first form fires the trigger even if there is no update.

Thanks for any advice.

Bruce