Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Apr 22, 2002

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 address

city                 state zip   contract
-------------------- ----- ----- --------
Lawrence             KS    66044 0
Nashville            TN    37215 0
Corvallis            OR    97330 1
Ann Arbor            MI    48105 1
Gary                 IN    46403 1
Rockville            MD    20853 1
Salt Lake City       UT    84152 1
Salt Lake City       UT    84152 1

(8 row(s) affected)

‘////////////////////////////////////////////////
/////////////////////////////////
SELECT IDENTITY(int, 1,1) AS ColNum,address.*
INTO address1
FROM address
‘////////////////////////////////////////////////
/////////////////////////////////

select * from address1
ColNum      city                 state zip   contract
----------- -------------------- ----- ----- --------
1           Lawrence             KS    66044 0
2           Nashville            TN    37215 0
3           Corvallis            OR    97330 1
4           Ann Arbor            MI    48105 1
5           Gary                 IN    46403 1
6           Rockville            MD    20853 1
7           Salt Lake City       UT    84152 1
8           Salt Lake City       UT    84152 1

(8 row(s) affected)
Somaiah Manukonda
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date