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.
Loading
Hirendra SisodiyaPosted Mar 29, 2010, 4:20 AM
sorry..Only one identity column can be created per table.you can not have two identity column.
which type you are perform DTS import-from any datasource or file????
you can update other column in each row after import.
thanks
Please mark as answere if it helps