游标简单使用

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