title: How to insert sequential numbers in primary key using select subquery?
body: <p>I am reading a table A and inserting the date in Table B (both tables are of same structure except primary key data type). In Table B, Primary key is int whereas in Table A it is UniqueIdentifier. </p>
  
  <p>INSERT INTO TableB
  (ID, Names, Address)
  (select ID, Names, Address from TableA)</p>
  
  <p>Now how can i insert int type incremental value (1,2,3,so on) in TableB instead of uniqueidentifier from TableA using above script.</p>
  
  <p>Help?</p>