SqlServer基础:游标
记录下今天用到的游标:
DECLARE @TempID INT
DECLARE @Number INT
SET @Number=1
DECLARE myCursor CURSOR FOR
SELECT MemberID FROM dbo.Member
OPEN myCursor
FETCH NEXT FROM myCursor INTO @TempID
WHILE(@@fetch_status=0)
BEGIN
UPDATE dbo.Member
SET MemberName='测试会员'+ CONVERT(VARCHAR,@Number,50)
WHERE MemberID=@TempID
SET @Number=@Number+1
FETCH NEXT FROM myCursor INTO @TempID
END
CLOSE myCursor
DEALLOCATE myCursor
待续.....
DECLARE @id INT
DECLARE @money INT
DECLARE cursor1 CURSOR FOR
SELECT IntegrateCardID,RemainSum FROM dbo.IntegrateCard
OPEN cursor1
FETCH NEXT FROM cursor1 INTO @temp,@money
WHILE ( @@fetch_status = 0 )
BEGIN
UPDATE dbo.IntegrateCard
SET PreRecharge = @money
WHERE IntegrateCardID = @id
FETCH NEXT FROM cursor1 INTO @TempMemeberID
END
CLOSE cursor1
DEALLOCATE cursor1
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步