怎样用SQL在标题栏上显示括号？？

joyv 2003-09-12 10:26:56

我的sql如下：
Select EquipNo as 条码ID ,EquipName as 工装名称 ,TestTime as 检定时间 ,TestReason as 检定原因 ,TestResult as 检定结果 ,HandTest as 送检人 ,TestBy as 检定人 ,Period as 检定周期(月)
from Test where (Period='2') ORDER BY EquipNo
在sql2000上运行出错：第 1 行: '月' 附近有语法错误。

如果要在标题栏上显示“（）”，怎样做？

...全文

78 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

zjcxc 元老 2003-09-12

打赏
举报

加上[],即下面的语句就行了:
Select EquipNo as 条码ID ,EquipName as 工装名称 ,TestTime as 检定时间 ,TestReason as 检定原因 ,TestResult as 检定结果 ,HandTest as 送检人 ,TestBy as 检定人 ,Period as [检定周期(月)]
from Test where (Period='2') ORDER BY EquipNo

joyv 2003-09-12

打赏
举报

谢谢各位！～

sdhdy 2003-09-12

打赏
举报

select 1 as '()'

happydreamer 2003-09-12

打赏
举报

Select EquipNo as 条码ID ,EquipName as 工装名称 ,TestTime as 检定时间 ,TestReason as 检定原因 ,TestResult as 检定结果 ,HandTest as 送检人 ,TestBy as 检定人 ,Period as '检定周期(月)'
from Test where (Period='2') ORDER BY EquipNo

cloudchen 2003-09-12

打赏
举报

select Peroid as '检定周期(月)' from table

txlicenhe 2003-09-12

打赏
举报

[检定周期(月)]

tiny_yan 2003-09-12

打赏
举报

加上[ ]或" "

Select EquipNo as 条码ID ,EquipName as 工装名称 ,TestTime as 检定时间 ,TestReason as 检定原因 ,TestResult as 检定结果 ,HandTest as 送检人 ,TestBy as 检定人 ,Period as [检定周期(月)]
from Test where (Period='2') ORDER BY EquipNo

joyv 2003-09-12