Date: 12/04/06 (Asp Dot Net)    Keywords: sql

I am trying to update multiple rows and multiple fields in sql using an update statement. So far I can't find a good way to do this. I've looked at using SQLBulkCopy object, but apparently that only works for inserts. I can open the connection, write all the separate update queries, then execute them, but this will take forever, almost as slow as updating the rows one by one. The schema of my datatable is different than that of the destination table.
So it looks like its going to be a for loop making updates unless someone knows of a better way...
thanks!

Source: http://community.livejournal.com/aspdotnet/79716.html