sql游标使用

 declare @c  varchar(17)  
 set @c =''  
 declare row_cursor cursor for select c from T  
 open row_cursor  
 fetch next from row_cursor into @c  
 while @@FETCH_STATUS=0  
 begin  
  exec dbo.proc_  @year,@c 
  fetch next from  row_cursor into @c  
 end   
 close row_cursor  
 deallocate row_cursor