declare @i int;
declare @a varchar(10);
set @i =50;
while(@i<60)
begin
set @a = 'a'+cast(@i as varchar);
exec(' alter table report_smart add '+@a+' nvarchar(30) ');
set @i = @i +1;
end
declare @i int;
declare @a varchar(10);
set @i =50;
while(@i<60)
begin
set @a = 'a'+cast(@i as varchar);
exec(' alter table report_smart add '+@a+' nvarchar(30) ');
set @i = @i +1;
end