title: How to update two columns in IF statement in SQL Server
body: <p>I have this table:</p>
  
  <pre><code>TableA (columnA, columnB,columnC)
  </code></pre>
  
  <p>and I have this T-SQL statement:</p>
  
  <pre><code>ALTER TRIGGER TableB ON TableA  
  AFTER UPDATE  
  AS             
  BEGIN   
      SET NOCOUNT ON;
  
      IF UPDATE(columnA)
      BEGIN
          UPDATE TableA
          SET ColumnX= GETDATE()      
          FROM ( ---- ---)
          WHERE --- = ---
      END
  END
  </code></pre>
  
  <p>My concern is how can I make it to two or more columns in the <code>IF UPDATE()</code> statement. Comma (<code>,</code>) is not working. </p>