DECLARE row CURSOR FOR( SELECT * FROM test )OPEN rowFETCH NEXT FROM row WHILE (@@FETCH_STATUS = 0 ) BEGIN FETCH NEXT FROM row END CLOSE row DEALLOCATE row 为什么多读取一个空行?
DECLARE row CURSOR FOR( SELECT * FROM test )OPEN rowFETCH NEXT FROM row WHILE (@@FETCH_STATUS = 0 ) BEGIN在这个地方操作你的语句,怎么会多一个空行呢 FETCH NEXT FROM row END CLOSE row DEALLOCATE row
FETCH NEXT FROM row的原因
-- 定义游标 DECLARE row CURSOR FOR( SELECT * FROM test ) -- 打开游标 OPEN row -- 从游标中去出一条数据 FETCH NEXT FROM row -- 游标取到数据时进行循环 WHILE (@@FETCH_STATUS = 0 ) BEGIN -- 事务处理 .... -- 从游标中去出一条数据 FETCH NEXT FROM row END -- 关闭游标 CLOSE row -- 释放游标 DEALLOCATE row
FOR( SELECT * FROM test )OPEN rowFETCH NEXT FROM row
WHILE (@@FETCH_STATUS = 0 )
BEGIN在这个地方操作你的语句,怎么会多一个空行呢
FETCH NEXT FROM row
END
CLOSE row
DEALLOCATE row
DECLARE row CURSOR
FOR( SELECT * FROM test )
-- 打开游标
OPEN row
-- 从游标中去出一条数据
FETCH NEXT FROM row
-- 游标取到数据时进行循环
WHILE (@@FETCH_STATUS = 0 )
BEGIN
-- 事务处理
....
-- 从游标中去出一条数据
FETCH NEXT FROM row
END
-- 关闭游标
CLOSE row
-- 释放游标
DEALLOCATE row
FOR( SELECT * FROM test )OPEN rowFETCH FROM row
WHILE (@@FETCH_STATUS = 0 )
BEGIN FETCH NEXT FROM row
END
CLOSE row
DEALLOCATE row