An Easy Way to Add a Record Number to an Existing Table Using T-SQL

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)

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.