title: Difference between update() and columns_updated()
body: <p>I am using SQL Server 2012.</p>
  
  <p>My table definition:</p>
  
  <pre><code>create table cust
  (
       cid int identity,
       cnm varchar(100),
       country varchar(100)
  )
  
  alter table cust 
    add constraint pk primary key clustered on cust(cid)
  </code></pre>
  
  <p>I am trying to create an audit record only when cnm or country column is updated.</p>
  
  <p>My 2 queries:</p>
  
  <pre><code>create trigger trig_nm on cust
  as
      if columns_updated(cnm, country)
      --create records.
  
  create trigger trig_nm on cust
  as
      if update(cnm) or update(country)
         --create records.
  </code></pre>
  
  <p>What is the difference between 2 queries?</p>