[좐]군의 To-Be

DECLARE    @cursor   CURSOR
,	@sql	NVARCHAR(1000)
,	@params	NVARCHAR(100)
DECLARE @id	INT
,	@name	NVARCHAR(200)

SELECT	@sql =N'SET @p_cur = CURSOR FORWARD_ONLY READ_ONLY FOR 
	SELECT top 10 id, name FROM dbo.sysobjects WITH(NOLOCK) WHERE id < 10;
	OPEN @p_cur'
SELECT	@params = N'@p_cur CURSOR OUTPUT'

EXEC sp_executesql
	@sql
,	@params
,	@p_cur	= @cursor	OUTPUT



FETCH NEXT FROM @cursor INTO @id, @name
WHILE (@@FETCH_STATUS=0)
BEGIN
	PRINT CAST(@id AS VARCHAR(10)) + ':' + @name
	FETCH NEXT FROM @cursor INTO @id, @name
END

CLOSE @cursor
DEALLOCATE @cursor

(0) (0)

Posted by 좐군