I need to update one column in a very large table. Can I bcp, bulk copy, bulk insert... one column from another table into an existing table? For example:

table RES column STATUS needs to be updated with the same column from another table (PROP).

I have looked at bcp but it looks like it wants to insert/update all columns in the row. I just need the one column updated and I need it done fast.

Any help would be appreciated.

Charlie.