生成编码号001,002,003 到999

[jidianxueyuan]

生成编码号001,002,003 到999动态生成999行

[叶子]

select top 999 identity(int,1,1) as id into #t 
from sys.objects o,sys.columns c
select right(1000+id,3) as num from #t
drop table #t

[苦苦的潜行者]

几天怎么都是连续数字/日期啊

[AcHerat]

select right(1000+number,3) as code
from master..spt_values
where type = 'p' and number between 1 and 999

[百年树人]

declare @i int
set @i=1
while @i<999
begin
 print right('000'+ltrim(@i),3);
 set @i=@i+1
end

[SqlServer2008]

select right('00'+convert(nvarchar(4),number),3) as num 
from Master.dbo.spt_values where type='p'
and number between 1 and 999

[jiangshun]

select top 999 right('00000'+rtrim(row_number() over(order by o.name)),3) 
from sys.objects o,sys.columns c

[水族杰纶]

;with t
as
(select 1 as num
 union all
 select num+1 from t
 where num+1<=999)
select right(1000+num,3) 
from t option(maxrecursion 0)

[kingtiy]

个个方法都不错