有一条SQL语句不知道怎么写,紧急求助 我要用一条SQL语句实现输出 01-60HOURS010203...585960以上的HOURS代码字段名称请高人相助! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select '01' as [hours]union allselect '02' as [hours]union allselect '03' as [hours]union all...union allselect '60' as [hours] select right('00'+ ltrim(number),2) from master..spt_values where type='p' And number between 1 and 60 select right('00'+ ltrim(number),2) from master..spt_values where type='p' And number between 1 and 60 select right('00'+ ltrim(number),2) from master..spt_values where type='p' And number between 1 and 60 万一number 的1-60间少了删除了一条记录呢 关于此sql语句的若干个问题 把结果集连接起来 数据库服务器性能监测的问题 求助一个SQL算平均后返回前五的查询 求救!! 急!!! 你一定知道sql server 2008 数据库镜像1418错误怎么解决。。。 存储过程问题,请执教,急 INSERT INTO……SELECT的急问题 sql server如何注册新的服务器? 高手求教:MSSQL2000在jdbc里不能执行两个语句?100分等待 求助求助...收缩数据库报错 对一个字段里的一段字符串模糊查询!!!!
union all
select '02' as [hours]
union all
select '03' as [hours]
union all
...
union all
select '60' as [hours]
where type='p' And number between 1 and 60
where type='p' And number between 1 and 60
select right('00'+ ltrim(number),2)
from master..spt_values
where type='p' And number between 1 and 60