T-SQL存储过程:在游标内的while循环中只插入集合中的第一行

CREATE PROCEDURE InsertFirstRowOnly
AS
BEGIN
    DECLARE @cursor CURSOR;
    DECLARE @data VARCHAR(100);

    -- 初始化游标
    SET @cursor = CURSOR FOR SELECT ColumnName FROM TableName;

    -- 打开游标
    OPEN @cursor;

    -- 获取集合中的第一行数据
    FETCH NEXT FROM @cursor INTO @data;

    -- 插入第一行数据
    INSERT INTO AnotherTableName (ColumnName) VALUES (@data);

    -- 关闭游标
    CLOSE @cursor;
    DEALLOCATE @cursor;
END;

CREATE PROCEDURE InsertFirstRowOnly
AS
BEGIN
    DECLARE @cursor CURSOR;
    DECLARE @data VARCHAR(100);
    DECLARE @counter INT;

    -- 初始化游标
    SET @cursor = CURSOR FOR SELECT ColumnName FROM TableName;

    -- 打开游标
    OPEN @cursor;

    -- 初始化计数器
    SET @counter = 1;

    -- 遍历集合中的数据
    WHILE @counter <= 1
    BEGIN
        -- 获取当前行数据
        FETCH NEXT FROM @cursor INTO @data;

        -- 插入第一行数据
        INSERT INTO AnotherTableName (ColumnName) VALUES (@data);

        -- 增加计数器
        SET @counter = @counter + 1;
    END;

    -- 关闭游标
    CLOSE @cursor;
    DEALLOCATE @cursor;
END;