system.data.sqlclient.sqlexception‘01’附近语法错误selecttbcp.cpidas期号,'01'as01,'02'as02,'03'as03,'04'as04,'05as05,'06'as06,'07'as07,"+"'08'as08,'09'as09,'10'as10,'11'as11,'12'as12,'13'as13,'14'as14,'15'as15,'16'as

Question

system.data.sqlclient.sqlexception ‘01’附近语法错误
select tb_cp.cpid as 期号,'01'as 01,'02'as 02,'03'as 03,'04'as 04,'05 as 05,'06'as 06,'07'as 07,"
+ " '08'as 08,'09'as 09,'10'as 10,'11'as 11,'12'as 12,'13'as 13,'14'as 14,'15'as 15,'16'as 16,'17'as 17,'18 as 18,'19'as 19,'20'as 20,"
+ " '21'as 21,'22 as 22,'23 as 23,'24 as 24,'25 as 25,'26'as 26,'27'as 27,'28'as 28,'29 as 29,'30'as 30,'31'as 31,'32'as 32,'33'as 33,"
+ " ' ' as 蓝,'01'as 001,'02' as 002,'03'as 003,'04'as 004,'05'as 005,'06'as 006,'07'as 007,"
+ " '08'as 008,'09' as 009,'10'as 010,'11'as 011,'12'as 012,'13'as 013,'14'as 014,'15'as 015,'16'as 016,tb_cp.one as 红1,tb_cp.two as 红2,tb_cp.three as 红3,tb_cp.four as 红4,tb_cp.five as 红5,tb_cp.six as 红6,tb_cp.blue as 蓝号,CInt(one)+CInt(two)+CInt(three)+CInt(four)+CInt(five)+CInt(six) as 红和,CInt(one)+CInt(two)+CInt(three)+CInt(four)+CInt(five)+CInt(six)+CInt(blue) as 总和,tb_cp.cprp as 开奖日期 from tb_cp where one is not null
错误消息：消息 102,级别 15,状态 1,第 1 行
'01' 附近有语法错误.
消息 105,级别 15,状态 1,第 5 行
字符串 'as 016,tb_cp.one as 红1,tb_cp.two as 红2,tb_cp.three as 红3,tb_cp.four as 红4,tb_cp.five as 红5,tb_cp.six as 红6,tb_cp.blue as 蓝号,CInt(one)+CInt(two)+CInt(three)+CInt(four)+CInt(five)+CInt(six) as 红和,CInt(one)+CInt(two)+CInt(three)+CInt(four)+CInt(five)+CInt(six)+CInt(blue) as 总和,tb_cp.cprp as 开奖日期 from tb_cp where one is not null;
' 后的引号不完整.
看了好久也没看出来
表已经建了的啊

Answer 1

把这些列用[]括起来
select tb_cp.cpid as 期号,'01'as [01],'02'as[02],'03'as [03],'04'as [04],'05' as [05],'06'as [06],'07'as [07],"
+ " '08'as [08],'09'as [09],'10'as [10],'11'as [11],'12'as [12],'13'as [13],'14'as [14],'15'as [15],'16'as [16],'17'as [17],'18' as [18],'19'as [19],'20'as [20],"
+ " '21'as [21],'22' as [22],'23' as [23],'24' as [24],'25' as [25],'26'as [26],'27'as [27],'28'as[ 28],'29' as [29],'30'as[ 30],'31'as [31],'32'as [32],'33'as[ 33],"
+ " ' ' as 蓝,'01'as[ 001],'02' as [002],'03'as [003],'04'as [004],'05'as [005],'06'as [006],'07'as [007],"
+ " '08'as [008],'09' as [009],'10'as[ 010],'11'as [011],'12'as [012],'13'as [013],'14'as [014],'15'as[ 015],'16'as [016],tb_cp.one as[ 红1],tb_cp.two as [红2],tb_cp.three as [红3],tb_cp.four as[ 红4],tb_cp.five as [红5],tb_cp.six as [红6],tb_cp.blue as [蓝号],CInt(one)+CInt(two)+CInt(three)+CInt(four)+CInt(five)+CInt(six) as [红和],CInt(one)+CInt(two)+CInt(three)+CInt(four)+CInt(five)+CInt(six)+CInt(blue) as [总和],tb_cp.cprp as [开奖日期] from tb_cp where one is not null