declare @str varchar(16)
set @str='135'
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
print @str
set @str='135'
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
print @str
set @str='135'
set @str=@str+cast(cast(rand()*10000000000000 as decimal(13,0)) as varchar)
print @str
set @str='135'
set @str=@str+cast(cast(rand()*100000000 as decimal(13,0)) as varchar)
print @str
set @str='135'
select @str = @str + cast(CAST( RAND()*100000000 as int) as varchar(9))
select @str
'135'+ltrim(cast(rand()*100000000 as int))
from
tb
declare @str varchar(16)
set @str='135'
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
set @str=@str+cast(cast(rand()*10 as int) as varchar)
print @str
select '135'+ltrim(cast(rand()*100000000 as int))
union all select '135'+ltrim(cast(rand()*100000000 as int))
union all select '135'+ltrim(cast(rand()*100000000 as int))
union all select '135'+ltrim(cast(rand()*100000000 as int))
union all select '135'+ltrim(cast(rand()*100000000 as int))
declare @str varchar(11)
set @str='135'
set @str=@str+left(ABS(checksum(newid())),8)
select @str