数据字符串:
String cmdText = "INSERT Student " +
"SELECT 'S1200902006','123456789','袁世凯','男',1,12341324,'汤臣一品','1991-11-1','[email protected]' UNION " +
"SELECT 'S1200902007','Aas256789','溥仪OO','男',1,12222224,'汤臣一品','1920-11-1','[email protected]' UNION"+
"SELECT 'S1200902008','46Sasd789','海伦00','男',1,14122324,'汤臣一品','1990-11-1','[email protected]' UNION"+
"SELECT 'S1200902009','12348Ssd9','霍金00','男',1,23412324,'汤臣一品','1990-11-1','[email protected]' UNION"+
"SELECT 'S1200902010','126978SS9','李大钊','男',1,23412324,'汤臣一品','1990-11-1','[email protected]' UNION"+
"SELECT 'S1200902011','52256789S','李世民','男',1,23412324,'汤臣一品','1910-11-1','[email protected]'";
如果把后面的四行注释掉就能够成功添加。
如果加上就报异常:System.Data.SqlClient.SqlException <0x80131904>:'S1200902008'附近有语法错误(从这行开始就不正常了) 高手解释下,这是哪儿出问题了?
String cmdText = "INSERT Student " +
"SELECT 'S1200902006','123456789','袁世凯','男',1,12341324,'汤臣一品','1991-11-1','[email protected]' UNION " +
"SELECT 'S1200902007','Aas256789','溥仪OO','男',1,12222224,'汤臣一品','1920-11-1','[email protected]' UNION"+
"SELECT 'S1200902008','46Sasd789','海伦00','男',1,14122324,'汤臣一品','1990-11-1','[email protected]' UNION"+
"SELECT 'S1200902009','12348Ssd9','霍金00','男',1,23412324,'汤臣一品','1990-11-1','[email protected]' UNION"+
"SELECT 'S1200902010','126978SS9','李大钊','男',1,23412324,'汤臣一品','1990-11-1','[email protected]' UNION"+
"SELECT 'S1200902011','52256789S','李世民','男',1,23412324,'汤臣一品','1910-11-1','[email protected]'";
如果把后面的四行注释掉就能够成功添加。
如果加上就报异常:System.Data.SqlClient.SqlException <0x80131904>:'S1200902008'附近有语法错误(从这行开始就不正常了) 高手解释下,这是哪儿出问题了?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货