If I have data rows in database and want to import data from data file with bcp utility in native mode, is there any solution (specified switch) that override data with same identity value in ID column?
+4
A:
Yes - -E to keep identity values in the file. Just type bcp at the command line to see a full list of options.
David M
2010-01-12 08:45:35
thanks david, my question is that if I have rows with duplicate identity value, what's the bcp manner? (I use -E switch)
masoud ramezani
2010-01-12 08:59:33
No, you have to choose one way or the other - maintain the identities, or have new ones.
David M
2010-01-12 09:04:45
thank you very much david
masoud ramezani
2010-01-12 09:19:19