Sql Server cursor

最新推荐文章于 2024-02-24 12:46:44 发布

霍夫曼

最新推荐文章于 2024-02-24 12:46:44 发布

阅读量302

点赞数

文章标签：数据库 sql sqlserver

本文链接：https://blog.csdn.net/hofmann/article/details/126893031

版权

数据库事务处理 SQL查询游标数据操作

关键词由CSDN通过智能技术生成

declare @PcrId bigint
declare @PcrIdList table(PCRID bigint)
insert into @PcrIdList select PCRID from (select distinct PCRID from dbo.[ExtendFields]) a where not exists(select PCRID from [dbo].[ExtendFields_Transform1] where PCRID=a.PCRID)
--select * from @PcrIdList

SET XACT_ABORT ON

declare pcrIdCursor cursor for select PCRID from @PcrIdList order by PCRID

open pcrIdCursor
fetch next from pcrIdCursor into @PcrId

while @@FETCH_STATUS = 0
begin 
    begin tran
        --print @PcrID;
        
        fetch next from pcrIdCursor into @PcrId
    commit tran;
end

close pcrIdCursor
deallocate pcrIdCursor
 
GO