[MS-SQL] 커서 / 루프 / 커서 사용하기 / CURSOR

 

 

 

   create table #tmp ( name nvarchar(10), pwd nvarchar(10))
   
   insert into #tmp values ('강감찬','111')
   insert into #tmp values ('김유신','222')
   insert into #tmp values ('이순신','333')
   
   DECLARE @Target_name nvarchar(10)
   
   DECLARE CUR CURSOR
   FOR SELECT name FROM #tmp
   
   OPEN CUR;
   
   Fetch Next From CUR into @Target_name
   
   While(@@FETCH_STATUS <> -1)
   BEGIN
	PRINT @Target_name
	
	FETCH NEXT FROM CUR INTO @Target_name
   END
   
   
   Close CUR;
   Deallocate CUR;