海量数据批量插入本地测试平均1秒

            DateTime begin = DateTime.Now;

            //string connectionString = "server=点或者服务器数据库ip;user id=账号;password=密码;database=数据库名;";<pre name="code" class="csharp">            string connectionString = "server=.;user id=sa;password=sa;database=Demo;";
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open(); 
                StringBuilder sql = new StringBuilder("");
                for (int j = 0; j < 100; j++)
                {
                    sql = new StringBuilder("");
                    sql.Append("insert into userinfo(UserName,UserPWD) VALUES ");
                    for (int i = 0; i < 1000; i++)
                    {
                        if (i == 999)
                            sql.Append("('").Append(i + 1).Append("',").Append("'cxh')");
                        else
                            sql.Append("('").Append(i + 1).Append("',").Append("'cxh'),");
                    }
                    SqlCommand com = new SqlCommand(sql.ToString(), conn);

                    com.ExecuteNonQuery();
                }
            }
            TimeSpan ts = DateTime.Now - begin;
            Console.Write("时间间隔:");
            Console.Write(ts.ToString());
            Console.Read();

CREATE TABLE [dbo].[UserInfo](
	[UserID] [bigint] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](255) NULL,
	[UserPWD] [varchar](255) NULL,
 CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

今天在网站找的 并且也自己测试过    是还不错  留着！有更好的方法欢迎共享~