title: How to rollback if any update is not success?
body: <p>I have written a transaction like:</p>
  
  <pre><code>    BEGIN TRAN
  
      UPDATE  [Table1]
      SET [Name] = 'abcd'
      WHERE   [ID] = 1
  
      UPDATE  [Table2]
      SET [Product] = 'efgh'
      WHERE   [ID] = 10
  
      UPDATE  [Table3]
      SET [Customar] = 'ijkl'
      WHERE   [ID] = 11
  </code></pre>
  
  <p>Now I want to rollback if any UPDATE is not success. For example in Table2 if there is no Product with ID=10 the transaction should be rolled back. How to do this?Please note that I am using <code>SQLServer 2000.</code> </p>