5.8w+
社区成员
- 主页
- .NET Framework
- ASP
- Web Services
- .NET互联网桌面应用
- VB
- 图表区
- 分析与设计
- 组件/控件开发
- AppLauncher
- 问答
能不能在存储过程中判断需要查询的字段？？
Select nzj.Auto_id,nzj.name,nzj.content,nzj.moment,C.City From VetanNew_nizaijian As nzj,VetanNew_City As C Where nzj.area = c.Number
nzj.moment的字段是1，2的类型，我想如果是1则输出a,是2则输出b,有可能实现么？
nzj.moment的字段是1，2的类型，我想如果是1则输出a,是2则输出b,有可能实现么？
...全文
请发表友善的回复…
发表回复
xiaohutushen 2004-10-27
Select nzj.Auto_id,nzj.name,nzj.content,
case nzj.moment
when '1' then 'a'
when '2' then 'b' end as moment,
C.City From VetanNew_nizaijian As nzj,VetanNew_City As C
Where nzj.area = c.Number
case nzj.moment
when '1' then 'a'
when '2' then 'b' end as moment,
C.City From VetanNew_nizaijian As nzj,VetanNew_City As C
Where nzj.area = c.Number
fxyfx 2004-10-27
Select nzj.Auto_id,nzj.name,nzj.content,case nzj.moment when 1 then 'a' when 2 then 'b' end as moment,C.City From VetanNew_nizaijian As nzj,VetanNew_City As C Where nzj.area = c.Number
hubinasm 2004-10-27
Select nzj.Auto_id,nzj.name,nzj.content,case nzj.moment when 1 then 'a' when 2 then 'b' else '无' end ,C.City From VetanNew_nizaijian As nzj,VetanNew_City As C Where nzj.area = c.Number
xiaohutushen 2004-10-27
up