--用游标实现循环
Declare @NavigatingZone nvarchar(20)
Declare @PostCode nvarchar(20)
Declare Cur Cursor For Select NavigatingZone,PostCode From TbFitDutyCode
Open Cur
Fetch next From Cur Into @NavigatingZone,@PostCode
While @@fetch_status=0
Begin
Update TbFitDutyCode Set NavigatingZone=@NavigatingZone,PostCode=@PostCode Where NavigatingZone=@NavigatingZone and PostCode=@PostCode
Fetch Next From Cur Into @NavigatingZone,@PostCode
End
Close Cur
Deallocate Cur
Declare @NavigatingZone nvarchar(20)
Declare @PostCode nvarchar(20)
Declare Cur Cursor For Select NavigatingZone,PostCode From TbFitDutyCode
Open Cur
Fetch next From Cur Into @NavigatingZone,@PostCode
While @@fetch_status=0
Begin
Update TbFitDutyCode Set NavigatingZone=@NavigatingZone,PostCode=@PostCode Where NavigatingZone=@NavigatingZone and PostCode=@PostCode
Fetch Next From Cur Into @NavigatingZone,@PostCode
End
Close Cur
Deallocate Cur
扫一扫
20
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
