declar @i int
while @I<=XX
begin
exec ('alter table table_'+cast(@i as varhcar) ='add column column_new .....')
@i=@i+q
end
while @I<=XX
begin
exec ('alter table table_'+cast(@i as varhcar) ='add column column_new .....')
@i=@i+q
end
set @i=0
while @i<最大表号
set @i=@i+1
begin
exec ('alter table table_'+cast(@i as varchar) ='add column column_new .....')
end
set @i=0
while @I<=XX
begin
exec ('alter table table_'+cast(@i as varhcar) +' add column column_new .....')
@i=@i+q
end