Using sqlserver2008, c/s mode, the client program data to the server, the server on a write your own not essentially a server, the server again submitted to essentially local preservation, now there are about 200 clients will be on the same day each month (the specific time point random), upload data to the server to perform the same program, this program at present about select6 times, each time after can produce dozens of insert statement, then every insert will be submitted to the server to perform a detailed, about will submit for hundreds of times,

But because the company network quality is poorer, replace the more common, if either the insert fails, the entire program would not be successful, I want to change now, select6 times, after the completion of all form a hundreds insert statement of packets, and then submitted to the server at a time, submitted by the server in a single transaction as a whole, the existing two problems consult everybody, first thanked the here:

1. I used a large post instead of multiple small submit method, can reduce the program execution failure caused by poor quality of the network,

2. Never use transaction to one-time submitted insert hundreds, I don't know what's the problem with no.