INF: Using BCP to Load Data into SQL Table with Unique Index (69283)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q69283 SUMMARY
BCP (bulk copy program) handles the loading of duplicate data into a table that has a unique index by stopping the processing of the data file and rolling back all records. In other words, no records are loaded into the table.
The rollback affects all rows up until the duplicate is encountered if no batchsize (-b) option was used.
In addition, if the index was created with IGNORE_DUP_KEY, the encountering of a duplicate during bcp has no effect. In other words, no rollback occurs and the bcp will continue.
| Modification Type: | Major | Last Reviewed: | 11/14/2003 |
|---|
| Keywords: | kbinfo KB69283 |
|---|
|