SQL Server Query Cursor Pattern

SqlServerQueryCursorPattern

DECLARE @tblName sysname
DECLARE @tblId INT
DECLARE @sql VARCHAR(MAX)

DECLARE cTable CURSOR FOR 
    SELECT [sql]
OPEN cTable
FETCH NEXT FROM cTable
INTO @sql

WHILE @@FETCH_STATUS = 0
BEGIN

    PRINT @sql

    FETCH NEXT FROM cTable INTO @tblName,@tblID

END
CLOSE cTable
DEALLOCATE cTable