declare @tbname int,@s varchar(8000)
set @tbname=1
while @tbname<100
begin
set @s = 'create table [A'+right('00'+ltrim(@tbname),3)+'] ([a] int,[b] varchar(50))'
exec(@s)
set @tbname=@tbname+1
end

create proc myTest
as
begin
  declare @tbNmae nvarchar(10),@int int
  while @int < 0
  begin
    exec('create table ' + @tbName + @int + '...')
  end
end

declare @sql varchar(8000),@i int
set @sql=''
set @i=0
while @i<=100
begin
    set @sql='create table A'+right(rtrim(1000+@i),2)+'(id int,name varchar(20))'
    exec(@sql)
    set @i=@i+1
end

create proc p_crttb
as
declare @sql varchar(8000),@i int
set @sql=''
set @i=0
while @i<=100
begin
    set @sql='create table A'+right(rtrim(1000+@i),2)+'(id int,name varchar(20))'
    exec(@sql)
    set @i=@i+1
end
go
exec p_crttb

create proc createtable
as
declare @str varchar(100),@i int
set @i=1
while @i<3
begin
select @str='create table A'+ right('000'+ltrim(@i),3)+'(ID int)'
exec(@str)
set @i=@i+1
end