title: SQL Identity with leading padded zeros
body: <p>I have marked a column as Identity in my table </p>
  
  <pre><code>create table Identitytest(
      number int  identity(1,001) not null,
      value varchar(500)
  )
  </code></pre>
  
  <p>I need the identity column to be incremented as <code>001,002,003</code>, etc.</p>
  
  <p>The database shows that it is inserting as <code>1,2,3</code>, etc.</p>
  
  <p>How can this be done?</p>