SQL server 2005循环创建和删除表

--create table

declare @i int declare @s Nvarchar(100)

set @i=0

while @i<1 begin

set @s= N'create table t'+cast(@i as varchar(10))+'(id int)'

exec(@s)

set @i=@i+ 1

end

--drop table

declare @i int declare @s Nvarchar(100)

set @i=0

while @i<1

begin set @s= N'drop table t'+cast(@i as varchar(10))

exec(@s)

set @i=@i+ 1

end

 

--drop table

  declare @i int ,@sql nvarchar(4000)
  set @i=0
  while @i<100
  begin
  set @sql='drop table [table' + cast(@i as varchar(8000))+']'
  exec( @sql)
  set @i=@i+1
  set @sql='' end