Question

sql server2000 如何让数字作为列名，用如下语句总是提示数字附近有语法错误，把数字改成大写就没有问题

select t.字段4,sum(t.1303) as 1303收入,sum(t.1302) as 1302收入, sum(t.1303) - sum(t.1302) as 差值 from (select 字段4,字段18 as 1303,0 as 1302 from [1303] union all select 字段4,0 as 1303,字段18 as 1302 from [1302] ) t group by t.字段4 having sum(t.1303) - sum(t.1302) > 300；
现在必须使用数字作为列名，该怎么办？

Answer 1

select
t.字段4,
sum([t.1303]) as [1303收入],
sum([t.1302]) as [1302收入],
sum([t.1303]) - sum([t.1302]) as 差值
from
(select
字段4,
字段18 as [1303],
0 as [1302]
from [1303]
union all
select
字段4,
0 as [1303],
字段18 as [1302]
from [1302]
) t
group by
t.字段4
having sum([t.1303]) - sum([t.1302]) > 300；

Answer 2

数字用单引号引起来嘛
as 1303 --> as '1303'

Answer 3

sql不能用数字作列名，试试用[]把数字括起来。

Answer 4

select id as '123' from tabname

追问

不行，因为t.1303部分没有解决，此部分若加引号则提示不能对字符串求和。

追答

那就别想着用数字做列名，换一种实现方式。