序列号问题？

[insert2003]

有表如下：
tb_Test
cstat cend val
03997194076110029 03997194076110528 500
03997194076108204 03997194076108778 575
......


cstat：开始值
cend：结束值
val：增加多少个

怎样实现序列号递增？

就是得到
03997194076110029
03997194076110030
.
.
.
03997194076110528
03997194076108204
03997194076108205
.
.
.
03997194076108778

[子陌红尘]

declare @t table(cstat varchar(20),cend varchar(20),val int)
insert into @t select '03997194076110029','03997194076110528',500
insert into @t select '03997194076108204','03997194076108778',575

set rowcount 1000
select identity(int,0,1) num into # from sysobjects a,sysobjects b
set rowcount 0

select
right('0000000000'+rtrim(cast(a.cstat as bigint)+b.num),17) as seq
from
@t a,# b
where
b.num<a.val
order by
seq


drop table #

[wwh999]

set rowcount 1000 ？学习了....