bulk insert to SQL Server, insert statements vs one insert XML statement?
- by Henry
The application layer (ColdFusion) needs to insert multiple rows onto SQL Server 2005.
I was thinking of using loop in app layer to construct multiple input statements and send to SQL Server over JDBC in a single connection.
My colleague however suggests to construct an XML and bulk insert the XML instead.
Which one is the better method?