Is there a way to do a bulk data update to sql server?
C#
2
Posts
2
Posters
0
Views
1
Watching
-
I'm looking for a way to update bulk data from DataTable to a SQL server since the updating procedure row at the time takes a lot of time in a large scale database as the one i work with.
you can use the concepts of OpenXML for bulk updates in sql server. this can minimize ur updates from a number of rows to be updated to 1. regards
sAqIb "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr.