devxlogo

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

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)
See also  11 Effective Keyword Research Tools and Techniques
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist