有一条SQL语句不知道怎么写，紧急求助

[almims]

我要用一条SQL语句实现输出 01-60

HOURS
01
02
03
...
58
59
60

以上的HOURS代码字段名称
请高人相助！

[jenhon]

select '01' as [hours]
union all
select '02' as [hours]
union all
select '03' as [hours]
union all
...
union all
select '60' as [hours]

[jwdream2008]

select right('00'+ ltrim(number),2)  from master..spt_values 
 where type='p' And number between 1 and 60

[yanweihuanghui]

select right('00'+ ltrim(number),2) from master..spt_values
where type='p' And number between 1 and 60

[jaydom]

select right('00'+ ltrim(number),2)  
from master..spt_values 
where type='p' And number between 1 and 60

[almims]

谢谢大家热情回复啊，先找个最优的试试，一会儿来加分

[almims]

我不知道通过系统表来实现这个功能，会不会换个版本什么的不稳定

[almims]

万一number 的1-60间少了删除了一条记录呢