title: Excluding column from T-SQL RowVersion update
body: <p>I have a database table in SQL Server that I am using T-SQL's <code>RowVersion</code> to record a <code>GenerationNumber</code> and detect have any records changed. This paradigm has worked successfully for my application, but now I want to add a column that does not increment the <code>RowVersion</code> column on <code>UPDATE</code>. </p>
  
  <p>Is there any way of excluding a column from the <code>RowVersion</code> increment? Or should I change the datatype of <code>RowVersion</code> to a <code>datetime</code> and handle it myself in a trigger? </p>
  
  <p>Any suggestions or ideas are welcome</p>