Wednesday, March 18, 2009

Simple cursor Example in Microsoft SQL Server

DECLARE @String nVARCHAR(MAX)
DECLARE @getInputBuffer CURSOR
SET @getInputBuffer = CURSOR FOR
SELECT Text FROM Table

OPEN @getInputBuffer

FETCH NEXT
FROM @getInputBuffer INTO @String

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT @String
FETCH NEXT
FROM @getInputBuffer INTO @String

END

CLOSE @getInputBuffer
DEALLOCATE @getInputBuffer

No comments: