select top 10000 ID=identity(1,1) into # from syscolumns a ,syscolumns b,syscolumns c
-------
生成递增:
insert T(Col)
select 'ZT9928'+right(100000+ID,4)+'CN' from #
select top 10000 ID=identity(1,1) into # from syscolumns a ,syscolumns b,syscolumns c
-------
生成递增:
insert T(Col)
select 'ZT9928'+right(100000+ID,4)+'CN' from #
declare @i int
declare @t_id varchar(20)
declare @temp table(t_id varchar(20))
set @i=1
while @i<=10000
begin
set @t_id=right('00000'+convert(varchar(5),@i),5)
set @t_id='ZT9928'+@t_id+'CN'
insert @temp(t_id) values (@t_id)
set @i=@i+1
end