Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2001-12-11 : 01:41:43
|
| hello,I do bulk insert from a file using BULK INSERT command.Like, if primary key violation occurs it rollbacks the whole operation without inserting other records.Is there any option that leaving the duplicate record the other records are to be inserted. |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2001-12-11 : 01:47:17
|
| AFAIK there is no such option...Why not place it into a temp table and then run an insert statement against the real table??DavidMA database is a set of axioms, the response to a query is a theorem, the process of deriving the theorem from the axioms is a proof, a proof is made by manipulating symbols according to agreed mathematical rules. |
 |
|
|
|
|
|
Bulk insert Problem