代替游标的循环
2011-03-02 14:24 通心菜 阅读(249) 评论(0) 编辑 收藏 举报
Declare @Loop int --循环变量
DECLARE @RowCnt INT --总记录
DECLARE @UserID INT
DECLARE @PubSites VARCHAR(8000)
Set @Loop = 1
SELECT @RowCnt=COUNT(*) FROM dbo.UserConfig
While @Loop < @RowCnt
Begin
--获取站点列表
SELECT @UserID=UserID,@PubSites=PubSites FROM(SELECT UserID,PubSites,ROW_NUMBER() OVER(ORDER BY ConfigID) AS RowNo FROM dbo.UserConfig)AS t WHERE RowNo=@Loop
UPDATE dbo.UserSite SET ActiveFlag=1 WHERE userid=@UserID AND SiteID IN(select F1 from split(@PubSites,','))
set @Loop=@Loop+1
PRINT CONVERT(varchar(10),@Loop)+'/'+CONVERT(varchar(10),@RowCnt)
End
DECLARE @RowCnt INT --总记录
DECLARE @UserID INT
DECLARE @PubSites VARCHAR(8000)
Set @Loop = 1
SELECT @RowCnt=COUNT(*) FROM dbo.UserConfig
While @Loop < @RowCnt
Begin
--获取站点列表
SELECT @UserID=UserID,@PubSites=PubSites FROM(SELECT UserID,PubSites,ROW_NUMBER() OVER(ORDER BY ConfigID) AS RowNo FROM dbo.UserConfig)AS t WHERE RowNo=@Loop
UPDATE dbo.UserSite SET ActiveFlag=1 WHERE userid=@UserID AND SiteID IN(select F1 from split(@PubSites,','))
set @Loop=@Loop+1
PRINT CONVERT(varchar(10),@Loop)+'/'+CONVERT(varchar(10),@RowCnt)
End
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步