在线等，一条sql出错了

Question

SET IDENTITY_INSERT [KD_SYS_RoleInfo] ON
insert into [KD_SYS_RoleInfo] ( [ID],[RoleName],[RoleDesc],[RoleElements],[IsShowMenuChild],[IsNeedCheck],[InfoOrder],[IsIndex],[IsDeleted],[TypeID],[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate],[Re] ) values 
( 1,'系统超级管理员','系统所有权限',
''1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','35','36','247','249','248','250','251','252','253','254','255','256','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','56','57','61','62','63','64','65','58','66','67','68','69','70','59','71','72','73','74','75','60','104','105','106','107','108','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','162','163','257','258','260','261','262','263','264','266','267','268','269','270','271','272','164','166','167','168','169','170','171','172','173','174','175','165','176','177','178','179','180','181','182','183','184','185','195','196','197','198','199','200','204','205','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','237','238','239','240','241','206','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','242','243','244','245','246'',
'是','否',1,'是','否',1,'','','admin','2010-12-18 11:03:17','' ); 
SET IDENTITY_INSERT [KD_SYS_RoleInfo] OFF
消息 102，级别 15，状态 1，第 5 行
'1' 附近有语法错误。

Answer 1

SET IDENTITY_INSERT [KD_SYS_RoleInfo] ON
insert into [KD_SYS_RoleInfo] ( [ID],[RoleName],[RoleDesc],[RoleElements],[IsShowMenuChild],[IsNeedCheck],[InfoOrder],[IsIndex],[IsDeleted],[TypeID],[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate],[Re] ) values 
( 1,'系统超级管理员','系统所有权限',
'
'1','2','3','4','5','6','7','8','9','10',
'11','12','13','14','15','16','17','18','19','20',
'21','22','23','24','25','26','27','28','29','30',
'31','32','35','36','247','249','248','250','251','252','253','254','255','256',
'37','38','39','40',
'41','42','43','44','45','46','47','48','49','50',
'51','52','53','54','56','57','61','62','63','64','65','58','66','67','68','69','70','59',
'71','72','73','74','75','60','104','105','106','107','108','76','77','78','79','80',
'81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100',
'101','102','103','109','110','111','112','113','114','115','116','117','118','119','120',
'121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140',
'141','142','143','144','145','146','147','148','149','150','151','152','153','154','155',
'156','157','158','159','162','163','257','258','260','261','262','263','264','266','267','268','269','270',
'271','272','164','166','167','168','169','170','171','172','173','174','175','165','176','177','178','179','180',
'181','182','183','184','185','195','196','197','198','199','200','204','205','207','208','209','210',
'211','212','213','214','215','216','217','218','219','220','221','237','238','239','240',
'241','206','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','242','243','244','245','246'
',
'是',
'否',
1,
'是',
'否',
1,
'',
'',
'admin',
'2010-12-18 11:03:17',
'' 
); 
SET IDENTITY_INSERT [KD_SYS_RoleInfo] OFF

Answer 2

,'246'',（这里也多了个'）
'是','否',1,'是','否',1,'','','admin','2010-12-18 11:03:17','' );  

Answer 3

参考,
1、''改成'''
2、'改成''insert into [KD_SYS_RoleInfo] ( [ID],[RoleName],[RoleDesc],[RoleElements],[IsShowMenuChild],[IsNeedCheck],[InfoOrder],[IsIndex],[IsDeleted],[TypeID],[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate],[Re] ) values  
( 1,'系统超级管理员','系统所有权限',
'''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'',''10'',''11'',''',
'是','否',1,'是','否',1,'','','admin','2010-12-18 11:03:17','' );  

Answer 4

如果没有引号的话，插入的值会不对应的消息 110，级别 15，状态 1，第 3 行
INSERT 语句中列的数目小于 VALUES 子句中指定的值的数目。VALUES 子句中值的数目必须与 INSERT 语句中指定的列的数目匹配。