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;