CURSOR 사용하기

AS
 DECLARE resourceNo_CURSOR CURSOR
  FOR Select No From resource  
 
 OPEN resourceNo_CURSOR 
 
 DECLARE @resourceNo int
 WHILE @@FETCH_STATUS = 0
 Begin    
  FETCH NEXT From resourceNo_CURSOR into @resourceNo    
  
    print @resourceNo
 
 END
 
 CLOSE resourceNo_CURSOR