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
SqlServer游标示例
最新推荐文章于 2023-08-11 21:15:59 发布