SQL Server @@ROWSCOUNT

[2018-04-19 목요일]

* 내용: @@ROWSCOUNT 사용

1. 쿼리

2. 확인

 

1. 쿼리

---

 

* @@ROWSCOUNT 쿼리 추가

※ OPEN_CURSOR 뒤에서 @@ROWSCOUNT 값 할당된다.

-- * CURSOR START POINT
DECLARE @BELNR VARCHAR(100)
DECLARE @COUNT INT
 
DECLARE PRINT_CURSOR CURSOR
FOR -- CURSOR 선언 및 값 INSERT
(
    SELECT BELNR
        , COUNT(*)
    FROM BOND_LIST_ZTFI0208
    WHERE BELNR IN (
              '1800002776'
            , '1800002649'
            , '1800002813'
            , '1800003452'
            , '0090008747'
            , '0090046841'
            , '0090084399'
        )
    GROUP BY BELNR
)
 
OPEN PRINT_CURSOR -- CURSOR OPEN
 
PRINT @@CURSOR_ROWS
 
FETCH NEXT
FROM PRINT_CURSOR
INTO @BELNR
    , @COUNT -- 첫 번째 CURSOR 값 변수에 할당
 
WHILE @@FETCH_STATUS = 0 -- CURSOR 다 FETCH 할 때까지 WHILE
BEGIN
    PRINT CONVERT(VARCHAR, @BELNR) + ' / ' + CONVERT(VARCHAR, @COUNT)
 
    FETCH NEXT
    FROM PRINT_CURSOR
    INTO @BELNR
        , @COUNT -- CURSOR가리키는 값 증가
END _
 
CLOSE PRINT_CURSOR -- CURSOR CLOSE
 
DEALLOCATE PRINT_CURSOR -- CURSOR 해제
    -- * CURSOR END POINT
 

 

2. 확인

---

 

* PRINT 확인

- @@ROWSCOUNT 값: 7