建了100个表,命名为table0...table99,请问哪位会用T-sql循环删除这些表
我的思路:
declare @i
set @i=0
while @i<100
begin
delete table string+i[ //这个不知道怎么表示
set @ i+=1
end
我的思路:
declare @i
set @i=0
while @i<100
begin
delete table string+i[ //这个不知道怎么表示
set @ i+=1
end
declare @i
set @i=0
while @i<100
begin
exec( 'drop table t' + cast(@i as varchar))
set @i+=1
end
set @i=0
while @i<100
begin
exec( 'drop table [' + cast(@i as varchar(8000))+']')
set @i=@i+1
end
set @i=0
while @i<100
begin
exec( 'drop table [table' + cast(@i as varchar(8000))+']')
set @i=@i+1
end
结贴了!
set @i=0 declare @sql varchar(max)
set @sql = ''
while @i<100
begin
set @sql = @sql + ' delete table' + cast(@i as varchar(3)) + ' '
set @ i+=1
end exec(@sql)