如何填充临时表、筛选临时表，然后循环访问(SQL Server)？

-- 创建临时表
CREATE TABLE #TempTable (
    ID INT,
    Name VARCHAR(50)
)

-- 插入数据
INSERT INTO #TempTable (ID, Name)
VALUES (1, 'John'), (2, 'Jane'), (3, 'Mike')

-- 筛选临时表
SELECT *
FROM #TempTable
WHERE Name LIKE 'J%'

-- 循环访问临时表
DECLARE @ID INT
DECLARE @Name VARCHAR(50)

DECLARE TempCursor CURSOR FOR
SELECT ID, Name
FROM #TempTable

OPEN TempCursor

FETCH NEXT FROM TempCursor INTO @ID, @Name

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在这里处理每一行数据
    PRINT 'ID: ' + CAST(@ID AS VARCHAR) + ', Name: ' + @Name

    FETCH NEXT FROM TempCursor INTO @ID, @Name
END

CLOSE TempCursor
DEALLOCATE TempCursor