sql语句中列名包含符号的话会报“语法错误”的错,如:
select '中国' as 查询区域(国家),key3 as 查询区域(省份),key4 as 查询区域(城市) from city
解决方案:
将含有符号的列名用中括号包起来[]
即改成如下:
select '中国' as [查询区域(国家)],key3 as [查询区域(省份)],key4 as [查询区域(城市)] from city
sql语句中列名包含符号的话会报“语法错误”的错,如:
select '中国' as 查询区域(国家),key3 as 查询区域(省份),key4 as 查询区域(城市) from city
解决方案:
将含有符号的列名用中括号包起来[]
即改成如下:
select '中国' as [查询区域(国家)],key3 as [查询区域(省份)],key4 as [查询区域(城市)] from city