sql事务对游标影响的示例
SET CURSOR_CLOSE_ON_COMMIT ON --设置为ON时,下面的代码报错
--SET CURSOR_CLOSE_ON_COMMIT OFF --设置为OFF(默认值时),下面的代码正常
DECLARE tb CURSOR LOCAL
FOR
SELECT id=1 UNION ALL SELECT id=1
OPEN tb
DECLARE @id int
FETCH tb INTO @id
WHILE @@FETCH_STATUS=0
BEGIN
BEGIN TRAN
IF @id%2=1
COMMIT TRAN
ELSE
ROLLBACK TRAN
FETCH tb INTO @id
END
CLOSE tb
DEALLOCATE tb