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)
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: