primary key

[Namarta]

I add all data into database from csv file and just insert primary key which are auto generated and not in the csv file.how i will add primary key into table.


Help me
Thanks in advance

[techguru]

you will need to load the csv to temp table, then load to the main table with identity assuing you are using sql server . if you are using oracle, then you need to create a sequence for this

another option is add a colimn in csv, put the sequence numbers before the load for the primary key