Dipali Patil

Dipali Patil

  • NA
  • 72
  • 79.2k

two columns I need to auto-increment

Mar 29 2010 3:14 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)