Using the IDENTITY function, you can add a Record number to an existing table.
For Example:
select * from addresscity state zip contract-------------------- ----- ----- --------Lawrence KS 66044 0Nashville TN 37215 0Corvallis OR 97330 1Ann Arbor MI 48105 1Gary IN 46403 1Rockville MD 20853 1Salt Lake City UT 84152 1Salt Lake City UT 84152 1(8 row(s) affected)‘/////////////////////////////////////////////////////////////////////////////////SELECT IDENTITY(int, 1,1) AS ColNum,address.*INTO address1FROM address‘/////////////////////////////////////////////////////////////////////////////////select * from address1ColNum city state zip contract----------- -------------------- ----- ----- --------1 Lawrence KS 66044 02 Nashville TN 37215 03 Corvallis OR 97330 14 Ann Arbor MI 48105 15 Gary IN 46403 16 Rockville MD 20853 17 Salt Lake City UT 84152 18 Salt Lake City UT 84152 1(8 row(s) affected)