使用 Cursor

Cursor很好用但要注意LOCK問題
但如果查詢條件夠快有使用到Index就不至於有LOCK
-- Declare the cursor from AgentMember
--宣告Cursor,指定Select資料表
DECLARE curSystem CURSOR FOR
select sName from DomainTemp order by iId desc
--Open Cursor
--開啟Cursor
OPEN curSystem
--Fetch Next Cursor
--指向第一筆Cursor資料
FETCH NEXT FROM curSystem
INTO @sNameTemp
declare @iNo tinyint
set @iNo=0
--迴圈查詢所有Cursor
WHILE @@FETCH_STATUS = 0
BEGIN
set @iNo=@iNo+1
--select @sNameTemp
--Fetch Next Cursor
--指向下一筆Cursor就像movenext
FETCH NEXT FROM curSystem
INTO @sNameTemp
END
--Cursor 迴圈===================
-- Close and deallocate the cusor from memory.
--關閉Cursor
close curSystem
--釋放Cursor記憶體
deallocate curSystem