declare @a int
declare @s char(123)
declare @s_curr char(10)
set @s_curr='0000000000'
set @s='0'
set @a=0
while(@a<12)
begin
set @s=@s_curr + @s
print @s
set @a=@a+1
end
print len( @s)
declare @s char(123)
declare @s_curr char(10)
set @s_curr='0000000000'
set @s='0'
set @a=0
while(@a<12)
begin
set @s=@s_curr + @s
print @s
set @a=@a+1
end
print len( @s)