February 1, 2007 at 6:13 am
I've one table and it has only one column (phone_number). I need to bulk insert from the file. The bulk insert is happening, but i need to check from the file when it is being inserted into the database whether the particular column values in the database should not be the same while you inserting.
When the bulk insert is happening then i need to check that only those number to inserted which is not already in the database. Could anyone help me out please in this regard. Is there any query for that for checking the database query bulk insert.
in advace thanks...
February 1, 2007 at 8:32 pm
Two ideas come to mind:
1) BULK INSERT into a temporary table and then use an INSERT with OUTER JOIN to load the actual table.
2) Set the BATCHSIZE = 1 and the MAXERRORS to some very large number. I've not tried to last myself, and given you've dropped the transaction commit down to row by row there's going to be a performance hit, so I'd lean towards #1.
K. Brian Kelley
@kbriankelley
February 2, 2007 at 11:30 am
Definitely #1.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply