[Mssql] 커서 예제

DECLARE @PHONE_NUMBER varchar(50)
DECLARE @DEST_INFO varchar(5000)
DECLARE @i int


DECLARE SelectCursor CURSOR FAST_FORWARD GLOBAL FOR

select cast(DEST_INFO as varchar) from send


OPEN SelectCursor

FETCH NEXT FROM SelectCursor INTO @PHONE_NUMBER    -- 위쿼리의 값이 @PHONE_NUMBER에 입력된다.

WHILE @@FETCH_STATUS <> -1  -- record가 존재하지 않을때 까지
	Begin
		If @@FETCH_STATUS <> -2 --record가 없을경우
			Begin

			End

		FETCH NEXT FROM SelectCursor INTO @PHONE_NUMBER

		If @@FETCH_STATUS <> 0 -- record가 존재할때
			Begin

			End

	End

CLOSE SelectCursor;
DEALLOCATE SelectCursor;