I don't understand the benefit outlined in the introduction.

 

Even with SQL 6.5 you could have simply submitted the 100 insert statements in one big string and executed it (ADO/ASP/.Net has supported this for years). 1 trip, 100 records. The extra T-SQL involved should be the same size as the extra XML tags involved.

 

i.e. cn.execute "INSERT Table VALUES ('Jim') INSERT Table VALUES ('Bob')"

 

The non-XML method should also be easier because you don't need to figure out how to transfer the xml file to the other server (assuming the sql server was on a different machine then your code). Transferring one XML file is easy. Transferring multiple XML files due to multiple users/threads will have implications (not to mention cleanup). Why bother when there is no benefit?

 

Of course, if you really needed to insert a LOT of records you wouldn't use either of these methods.