1.应该是是两个游标'同时'取第一行,然后'同时'取第二行.2.
FETCH FIRST FROM CursorOne INTO 变量
while @@FETCH_STATUS = 0
Begin
FETCH FIRST FROM CursorTwo INTO -- 用FIRST
while @@FETCH_STATUS = 0
begin
FETCH NEXT FROM CursorTwo INTO 变量
end
FETCH NEXT FROM CursorOne INTO 变量
End
FETCH FIRST FROM CursorOne INTO 变量
while @@FETCH_STATUS = 0
Begin
FETCH FIRST FROM CursorTwo INTO -- 用FIRST
while @@FETCH_STATUS = 0
begin
FETCH NEXT FROM CursorTwo INTO 变量
end
FETCH NEXT FROM CursorOne INTO 变量
End
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货