游标的问题

[boy1912]

在游标中如何实现依次提取多行数据。

[愉快的登山者]

使用循环：
DECLARE cur1 CURSOR
FOR select * from web_inventory where item_no='1'
OPEN cur1
FETCH NEXT FROM cur1
While @@FETCH_STATUS = 0
begin
..........
FETCH NEXT FROM cur1
End
CLOSE cur1
DEALLOCATE cur1

[愉快的登山者]

使用循环：
DECLARE cur1 CURSOR
FOR select * from web_inventory where item_no='1'
OPEN cur1
FETCH NEXT FROM cur1
While @@FETCH_STATUS = 0
begin
..........
FETCH NEXT FROM cur1
End
CLOSE cur1
DEALLOCATE cur1

[boy1912]

DEALLOCATE cur1

这个什么意思？有什么用？