Hi! Everyone, I know this is Oracle discussion group but still I am putting question from SQL server hoping I get answer from some of you. Right now I am doing insert into table using BCP. I was wondering can I do update and delete using BCP. Can anyone can also provide me with good URL for BCP? thanks, Shivani
I did a Google search and found this response to someones question there.
It would take forever to copy millions of rows in one insert statement or through VB. BCP can help you load data in bulk, but if you have some logic involved that is making you be selective on what data to insert, then BCP is not the answer either.
Seems from that that it is simple a bulk loader (inserts) only. And from other cursory looks at the Newsgroup for ns-sqlserver, it doesn't appear so, but you will have to do your own search there to be positive. Remember, I don't use SQL Server. Mark
As a different suggest, you could BCP the data into a staging table, a table that you create that matches the final destination table, then create a stored procedure that will go through the records, see if it already exists. If not insert, otherwise update. Mark