Recently, "primary school student" wrote a blog post about batch data import to the database. The experimental tool is. NET + SQL Server. Many netizens expressed their interest in this article, which is also a hot topic in 24 hours. At the same time, some netizens also used different tools to challenge the 4-second limit. I think that if we join the challenge, we must abide by the challenge rules and use consistent tools and environments for experiments.
We are looking for you to use. NET + SQL Server to import dataProgramIt's useless to talk on paper. Come and show your strength!
Lab requirements:
The four-second condition is not without preconditions. Since it is a challenge, we should abide by the following rules:
1.. NET platform development, using ADO. Net to operate databases
2. The database is an SQL Server, single form field (Table Name: tableb, field name: value1, nvarchar (50 ))
3. Do not use stored procedures
41 thousand pieces of data is a test unit
5. hardware configuration 2*2.0 gb cpu, 2 GB memory
Collection method:
Let's take the finalCode, Sent to my mailbox aicken@live.cn 23 days ago. The code must be bug-free, egg-free, and Virus-free. I will be realistic and run your code.
Code example: http://www.cnblogs.com/isline/archive/2010/03/18/1688783.html
It makes sense to observe the rules in that sentence!