declare @i int,@sql varchar(100)
set @i=0
while(@i<10)
begin
set @sql='truncate table mytable'+rtrim(@i)
exec(@sql)
set @i=@i+1
end
set @i=0
while(@i<10)
begin
set @sql='truncate table mytable'+rtrim(@i)
exec(@sql)
set @i=@i+1
end
set @i=0
while(@i<10)
begin
set @i=@i+1
exec('truncate table mytable'+@i)
end
declare @i int
set @i=0
while(@i<10)
begin
set @i=@i+1
exec('truncate table mytable'+cast(@i as char(2)))
end