1、 循环插入  2 sql2008支持insert into A("Name")values("dog"),("cat"),("d")3使用类库SqlBlukCody 类进行高效插入  1万条不要1秒   DataTable dt = new DataTable();            dt.Columns.Add("C2Name", typeof(string));            for (int i = 0; i < 100000; i++)            {                DataRow dr = dt.NewRow();                dr["C2Name"] = "test" + i;                dt.Rows.Add(dr);            }            string strconn = "server=.;database=CDStudent;uid=sa;pwd=sa";            System.Diagnostics.Stopwatch st = new System.Diagnostics.Stopwatch();            st.Start();            using (SqlBulkCopy copy = new SqlBulkCopy(strconn))            {                              //将内存表中的列明与数据库表的列明坐一一映射                copy.ColumnMappings.Add("C2Name", "CName");