Declare @WZ_SN varchar(20)
Declare @WZ varchar(20)
Declare Cur Cursor For
select char_ZWSZB_SN,vchar_ZWSZB_ZhiWuMing from tbZhiWuSheZhiBiao
Open Cur
Fetch next From Cur Into @WZ_SN,@WZ
While @@fetch_status=0
Begin
Update tbYuanGongXinXiBiao Set vchar_YGXXB_ZhiWu=@WZ where vchar_YGXXB_ZhiWu=@WZ_SN
Fetch Next From Cur Into @WZ_SN,@WZ
End
Close Cur
Deallocate Cur
游标简单使用
最新推荐文章于 2021-02-05 05:32:29 发布