sqlserver存储过程

declare  @a int, @sZoneName varchar(40), @str2 varchar(400);set @a=1;set @sZoneName = 'zone';while @a<10 begin        set @sZoneName = 'zone0' + cast(@a as char(4))    print @sZoneName;set @str2 = 'select max(end_date_mon) a from ' + @sZoneName;exec(@str2);    set @a=@a+1;end;