Wednesday, March 7, 2012

Bulk Insert a DataTable into SQL DataBase

Hi All!!
I need to export a whole datatable to the database, through bulk insert or any other method..
Can any body help me in that??
Yes, col's in the database table and datatable are same!!
Thx,
Regards,
Nilee..
Try the link below to use INSERT INTO with column list it give you control of the order of the insert. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_5cl0.asp

No comments:

Post a Comment