SET NOCOUNT ON;
    create table #tmp
    (id int identity (1,1),value int);
 
    insert into #tmp (value) values(10);
    insert into #tmp (value) values(20);
    insert into #tmp (value) values(30);
 
    select * from #tmp;
 
    declare @tmp_id int,@tmp_value int;
    declare tmpCursor cursor for 
    select t.id,t.value from #tmp t
    --order by t.id;
 
    open tmpCursor;
 
    fetch next from tmpCursor into @tmp_id,@tmp_value;
 
    while @@FETCH_STATUS = 0
    begin
        print 'ID: '+cast(@tmp_id as nvarchar(max));
 
        if (@tmp_id = 1 or @tmp_id = 2)
            insert into #tmp (value)
            values(@tmp_value * 10);
 
        fetch next from tmpCursor into @tmp_id,@tmp_value;
    end
 
    close tmpCursor;
    deallocate tmpCursor;
 
    select * from #tmp;
    drop table #tmp;

我们可以在print的帮助下观察游标如何解析#tmp表中的新行.但是,如果我们在游标声明中通过t.id取消注释顺序 – 则不会解析新行.

这是预期的行为吗？