http://www.brentozar.com/archive/2009/09/whats-on-my-bookshelf/
sql = "INSERT INTO employees VALUES (?, ?, ?)" + ";INSERT INTO employees VALUES (?, ?, ?)" + ... ";INSERT INTO employees VALUES (?, ?, ?)"; cmd.CommandText = sql; cmd.Prepare(); cmd.Parameters[0].Value = id[0]; cmd.Parameters[1].Value = name[0]; cmd.Parameters[2].Value = salary[0]; ... cmd.Parameters[27].Value = id[9]; cmd.Parameters[28].Value = name[9]; cmd.Parameters[29].Value = salary[9]; cmd.ExecuteNonQuery();













