SqlServer游标示例

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,@areaname
End 
Close Cur 
Deallocate Cur