SQL SERVER 顺序遍历数据表和修改

背景:

数据在数据库中是按日期进行表创建, 

例如增加一列或者删除一列,于是要遍历表.

 

 

T-SQL 执行语句示例:

declare @begin datetime,@end datetime, @dt datetime
set @begin = '2019-07-09'
set @dt= @begin
set @end = '2019-11-18'
declare @tableanme varchar(500), @sql char(500)
while (@dt < @end)
begin
    set @tableanme = 'rm_resistance_' + convert(varchar(10),@dt,112)
    print @tableanme
    set @sql = 'alter table ' +  @tableanme + ' add idx smallint' 
    exec(@sql)
    set @sql = 'update ' + @tableanme + ' set idx = 0 where idx is null and data0 is not null'
    exec(@sql)
    set @dt=dateadd(DAY,1,@dt)
end