This method is the most basic way, most people will think of this approach. Insert statement does not seem suitable for high-volume operations, is not this it? The data of this method will be 100 million divided into 10 batches, each 100,000, one transaction per 100,000, 10 times to import the database. Basic statement: Insert Into TableB (Value1) values ​ ​ (' " +i+" ' ) : i statement is an accumulation variable in the host program, used to populate the database field values.

C#100万条数据导入SQL+SERVER数据库仅用4秒+(附源码)
.................................................\C#100万条数据导入SQL SERVER数据库仅用4秒 (附源码)
.................................................\.................................................\C#100万条数据导入SQL SERVER数据库仅用4秒 (附源码).docx
.................................................\.................................................\Data
.................................................\.................................................\Data.rar
.................................................\.................................................\....\100w.txt
.................................................\.................................................\....\20w.txt
.................................................\.................................................\sqltest.rar
.................................................\.................................................\说明.doc

• We are an exchange download platform that only provides communication channels. The downloaded content comes from the internet. Except for download issues, please Google on your own.
• The downloaded content is provided for members to upload. If it unintentionally infringes on your copyright, please contact us.
• Please use Winrar for decompression tools
• If download fail, Try it againg or Feedback to us.
• If downloaded content did not match the introduction, Feedback to us，Confirm and will be refund.
• Before downloading, you can inquire through the uploaded person information

Nothing．