[펌] [커서]사용예

Pub테이블의 총 줄수를 알고 싶을‹š

 

SET NOCOUNT ON

DECLARE cur_konan_Test CURSOR FAST_FORWARD
FOR
SELECT name FROM sysobjects WHERE xtype='U'

OPEN cur_konan_Test

DECLARE @v_name VARCHAR(100)

FETCH NEXT FROM cur_konan_Test INTO @v_name

WHILE @@FETCH_STATUS = 0
BEGIN
SELECT 'SELECT COUNT(*) FROM ' +@v_name
FETCH NEXT FROM cur_konan_Test INTO @v_name
END

--커서 CLOSE
CLOSE cur_konan_Test

--커서 DEALLOCATE
DEALLOCATE cur_konan_Test
GO