RESTORE DATABASE MyNwind1 FROM MyNwind1 RESTORE DATABASE MyNwind2 FROM MyNwind2 ... RESTORE DATABASE MyNwind8 FROM MyNwind8
declare @i as int set @i = 1 declare @sql as varchar(100) while @i <= 8 begin set @sql = 'RESTORE DATABASE MyNwind' + cast(@i as varchar) + ' FROM MyNwind' + cast(@i as varchar) exec(@sql) set @i = @i + 1 end
RESTORE DATABASE MyNwind2 FROM MyNwind2
...
RESTORE DATABASE MyNwind8 FROM MyNwind8
set @i = 1
declare @sql as varchar(100)
while @i <= 8
begin
set @sql = 'RESTORE DATABASE MyNwind' + cast(@i as varchar) + ' FROM MyNwind' + cast(@i as varchar)
exec(@sql)
set @i = @i + 1
end