title: Unique random integer as primary key ID instead of auto increment
body: <p>Right now I have one table of members with table primary key 'id' as auto incremented.</p>
  
  <p>I want that instead of auto increment, it will <b>generate a random integer of 5-6 digits</b> and put that as '<b>id</b>'. As every 'id' is primary key so generated int will be unique. Any ideas to implement this on sql server will help.  </p>