游标

最新推荐文章于 2024-09-17 14:08:20 发布

原创最新推荐文章于 2024-09-17 14:08:20 发布 · 234 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#游标

Sql笔记专栏收录该内容

8 篇文章

订阅专栏

–游标使用方法
https://blog.youkuaiyun.com/lockepeak/article/details/2632904

DECLARE SNImport_Cursor CURSOR FOR
select LotSN,LocationNO from lot  where ParentLotId='B1430329C762' and  LocationNO=14
declare @LOTSN varchar(50)
declare @LocationNO int
OPEN  SNImport_Cursor
FETCH NEXT FROM SNImport_Cursor
INTO @LOTSN,@LocationNO

while @@FETCH_STATUS = 0
BEGIN

declare @LocationNO1 int 
		update lot set  LocationNO=10 where lotsn=@LOTSN
fetch next from SNImport_Cursor into @LOTSN,@LocationNO --将游标向下移1行
END
close SNImport_Cursor                   --关闭游标
deallocate SNImport_Cursor