SqlServer游标示例

发布时间：2020-12-12 15:32:49 所属栏目：MsSql教程来源：网络整理

导读：declare @areaid varchar(100) declare @areaname varchar(100) declare Cur cursor? for select code as areaID,[name] as areaName? from dbo.province open Cur Fetch next From Cur Into @areaid,@areaname While @@fetch_status=0??? Begin ??? print('

declare @areaid varchar(100)
declare @areaname varchar(100)
declare Cur cursor? for
select code as areaID,[name] as areaName? from dbo.province
open Cur
Fetch next From Cur Into @areaid,@areaname
While @@fetch_status=0???
Begin
??? print('insert into tb_area(areaid,areaname) values(' +@areaid +',''' + @areaname +''')')??? Fetch Next From Cur Into @areaid,@areanameEnd? Close Cur? Deallocate Cur

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!