MS SQL Cursor 語法

DECLARE MY_CURSOR Cursor FOR
([Select 語法])
open MY_CURSOR
FETCH NEXT FROM MY_CURSOR Into [接收變數]
--判斷狀態
WHILE(@@FETCH_STATUS=0)
--中間程式段
begin
[處理程式]
--移至下一筆
FETCH NEXT FROM MY_CURSOR INTO [接收變數]
end
CLOSE MY_CURSOR
DEALLOCATE MY_CURSOR