游标示例

SET NOCOUNT ON

begin tran

DECLARE @newsid varchar(80)
DECLARE @ishaveAnnex varchar(100)

DECLARE vendor_cursor CURSOR FOR 
SELECT [newsid] FROM [News]

OPEN vendor_cursor    
FETCH NEXT FROM vendor_cursor INTO @newsid

WHILE @@FETCH_STATUS = 0
BEGIN

select @ishaveAnnex =ishaveAnnex from News where newsid = @newsid

if (@ishaveAnnex = '1')
    begin
        update News set ishaveAnnex = '0' where newsid = @newsid
    end
else if (@ishaveAnnex = '0')
    begin
        update News set ishaveAnnex = '1' where newsid = @newsid
    end
    FETCH NEXT FROM vendor_cursor INTO @newsid
    
END
CLOSE vendor_cursor
DEALLOCATE vendor_cursor
if @@error<>0
    rollback tran
else
    commit tran