title: Can SQL server instead of update force insert a new row
body: <p>Is it possible in SQL Server 2008+ to force an <code>UPDATE</code> statement on table to be transformed into <code>INSERT</code> statement, thus creating new row with the old and updated columns?</p>