select id, case when ismoney=1 or ismoney=2
then cname+"付费"
else cname
end,
address,zip,tel,fax,url,ismoney
from main where left(newtype,4)=1510 order by area,cname
then cname+"付费"
else cname
end,
address,zip,tel,fax,url,ismoney
from main where left(newtype,4)=1510 order by area,cname
解决方案 »
- rar压缩bak文件
- 在SQL2005ReportingServices如何实现这样的汇总..
- sql数据库文件删除后恢复,不能附加数据库
- 关于sql server存储器过程,大师们来,送分送分!!!!!!!!!!!!!!!!!!!!!!
- 非常弱弱弱的问题
- 在游标中如何使用变量替代select_statement语句?
- 【!!!!又来一个简单的查询问题!!!!】
- 用ODBC API连接数据库, 能实现连接池吗?
- 重提一下SQL语句的要求,看怎么写
- sql 服务器怎么做,怎样在客户端连接到服务器
- 基础问题:我有一段从SQL脚本,怎么用它在另一个库中建立一个表啊
- 各位:菜鸟级的问题,我有个数据库是SQLSERVER的,如何打开?
case when ismoney=1 or ismoney=2 then ismoney+'付费' else ismoney end
from main
where left(newtype,4)=1510 order by area,cname
then cname+"付费"
else cname
end,
address,zip,tel,fax,url,ismoney
from main where left(newtype,4)=1510 order by area,cname否则会报错
then cname+N'付费'
else cname
end,
address,zip,tel,fax,url,ismoney
from main where left(newtype,4)=1510 order by area,cname
case when ismoney=1 or ismoney=2 then cname+"付费" else cname
end as cname,address,zip,tel,fax,url,ismoney
from main where left(newtype,4)=1510 order by area,cname
else cname ''
end, address,zip,tel,fax,url,ismoney
from main where left(newtype,4)=1510 order by area,cname