Home Forums SQL Server 7,2000 T-SQL How to get sequence number? RE: How to get sequence number?
Antares686
SSC Guru
Points: 125444
More actions
June 3, 2003 at 3:59 am
#459490
There are several ways to do this. Most folks will just create a temp table with an IDENTITY column and insert the data, or add an IDENTITY column to the current table.