游标使用示例

最新推荐文章于 2024-02-02 09:29:03 发布

Daemon8473

最新推荐文章于 2024-02-02 09:29:03 发布

阅读量309

点赞数

本文链接：https://blog.csdn.net/daemon8473/article/details/5023434

版权

该游标为实物配租记录赋房屋Id的值

--声明一个游标 declare my_cursor cursor for select h.id,h.swhouseaddress from lzhouse h,lzhouseleaseinfo hs where h.swhouseaddress=hs.renthouseaddress and h.swhouseusearea=hs.renthouseusearea and hs.houseid is null --打开游标 open my_cursor --声明变量 declare @hid numeric(19,0),@address varchar(200),@i int set @i=1 fetch next from my_cursor into @hid,@address while(@@fetch_status=0) begin print '第'+str(@i)+ '条：swHouseAddress: ' + @address set @i = @i +1 update lzhouseleaseinfo set houseid = @hid where renthouseaddress = @address fetch next from my_cursor into @hid,@address end --关闭游标 close my_cursor --删除游标 deallocate my_cursor