two columns I need to auto-increment

Mar 29 2010 3:13 AM

Can I have two Identity columns? If not, please solve below problem.

I have two columns I need to auto-increment. One(ID) starts at 1, the other(username) at 1000.

I'm performing a DTS import of roughly 11,000 records and want the two columns to increment along with the import.

Answers (1)

Google Earth

two columns I need to auto-increment