title: Auto populate binary column in SQL Server
body: <p>I have a table with structure like this:</p>
  
  <pre><code>CREATE TABLE tb_comm_hist_xfer (
          tb_comm_hist_xfer_id binary(16) NOT NULL,
          tb_old_customer_id int NOT NULL,
          tb_customer_id int NULL,
          date_entered datetime NOT NULL
      );
  </code></pre>
  
  <p>I want to make <code>tb_com_hist_xfer_id</code> column as auto populated column like <code>IDENTITY</code> property. But I can't use <code>IDENTITY</code> for binary types. What is the alternative for me?</p>