ALTER PROCEDURE [dbo].[xuexiao]
AS
BEGIN
declare @id int
declare @yiji nvarchar(50)
declare @erji nvarchar(50)
declare @sanji nvarchar(50)
declare xuexiao_cursor cursor
for select id,yiji,erji,sanji from sys_school2 where areaid is null
Open xuexiao_cursor
fetch next from xuexiao_cursor into @id,@yiji,@erji,@sanji
While(@@Fetch_Status = 0)
Begin
declare @regionid int
select @regionid=regionid from Sys_Regions where layer=3 and REPLACE(name,' ','') = @sanji and provincename like (@yiji + '%') and cityname like (@erji + '%')
update Sys_School2 set areaid=@regionid where id=@id
--select * from sys_school2 where id=@id
--select @regionid
fetch next from xuexiao_cursor into @id,@yiji,@erji,@sanji
End
Close xuexiao_cursor
Deallocate xuexiao_cursor
END
sql 游标
最新推荐文章于 2023-12-13 15:32:27 发布