数据库中有表h_jiesuan1、h_jiesuan2、h_jiesuan3。。。到h_jiesuan74
以下SQL代码,批量为这些表添加相同的列“AdvTag”,设置默认值为“0”,值更新为“0”
declare @i int
set @i = 1
declare @sql nvarchar(4000)
set @sql = '
alter table h_jiesuan' + cast(@i as nvarchar) + ' add AdvTag int default 0 go update h_jiesuan' + cast(@i as nvarchar) + ' set AdvTag = 0 go'
while (@i <= 74)
begin
exec @sql
end