How to quickly write a datatable into sql server?
Database
2
Posts
1
Posters
0
Views
1
Watching
-
We know it is quite easy to fetch data from sql server to datatable with dataadaptor of ado.net. However, i want to store my query result with over 2000 records to sql server now. Is there any good approach that could store this datatable immediately to sql server? Any idea is appreciated! Thank u in advance! :rose:
-
We know it is quite easy to fetch data from sql server to datatable with dataadaptor of ado.net. However, i want to store my query result with over 2000 records to sql server now. Is there any good approach that could store this datatable immediately to sql server? Any idea is appreciated! Thank u in advance! :rose:
sorry to add that the format of the query result is not determined at first. waiting for ur reply!