Monday, August 27, 2012

Simple SQL Cursor for Reference

SELECT * FROM #tmpTab;           
                DECLARE @x nvarchar(400)
                DECLARE cursorName CURSOR
                FOR Select Kju FROM #tmpTab
                                OPEN cursorName
                                FETCH NEXT FROM cursorName INTO @x
                                WHILE @@FETCH_STATUS = 0
                                                BEGIN
                                                EXEC sp_executesql @x
                                                PRINT @x
                                                FETCH NEXT FROM cursorName
                                                INTO @x
                                                END
                                CLOSE cursorName
                                DEALLOCATE cursorName

No comments:

Post a Comment