title: Insert record into table where ID is hashed?
body: <p>I am trying to insert a record into a table which has two keys: <code>TableNo int</code> and <code>RateID varchar32</code>.</p>
  <p>Both don't allow nulls. The issue I have is if I insert a record from backend using insert into I have to specify a <code>RateID</code>, so if I give it 0 or 1 or 3 it works however when I insert record from frontend the system generates a unique 32 character reference. I am trying to recreate this and wondering how the system is generating the unique ID.</p>
  <p>This is the code captured from a SQL Server trace;</p>
  <pre><code>exec sp_executesql 
  N'INSERT INTO BTRRTEmpls (TableNo, Employee, EffectiveDate, Rate, RateID) 
  VALUES (@TableNo, @Employee, @EffectiveDate, @Rate, @RateID)',
      N'@TableNo int,@Employee varchar(6),@EffectiveDate datetime,@Rate decimal(4,2),@RateID varchar(32)',
      @TableNo=1111,@Employee='781.WM',@EffectiveDate='2020-01-01 
  00:00:00',@Rate=45.65,@RateID='A010589973F841C28EB8E4356D0B6CFC'
  </code></pre>
  <p>How is this value <code>A010589973F841C28EB8E4356D0B6CFC</code> for <code>@RateID</code> generated?</p>
  <p><a href="https://i.stack.imgur.com/Cjx6s.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Cjx6s.jpg" alt="Screenshot of Table" /></a></p>