/****** 更新用户表 中心ID ******/
--申明一个游标
DECLARE MyCursor CURSOR
FOR SELECT [CenterName],[CenterID] FROM [Wcapp_BaseDataStore].[dbo].[MetenCenterModels]
--打开一个游标
OPEN MyCursor
--循环一个游标
DECLARE @CenterName nvarchar(64),@CenterID nvarchar(10)
FETCH NEXT FROM MyCursor INTO @CenterName,@CenterID
WHILE @@FETCH_STATUS =0
BEGIN
print 'name'+@CenterName
update [Wcapp_SignInfoStore].[dbo].[Act_CenterDynamic]
set CenterId = @CenterID
where centername = @CenterName
FETCH NEXT FROM MyCursor INTO @CenterName,@CenterID
END
--关闭游标
CLOSE MyCursor
--释放资源
DEALLOCATE MyCursor
--申明一个游标
DECLARE MyCursor CURSOR
FOR SELECT [CenterName],[CenterID] FROM [Wcapp_BaseDataStore].[dbo].[MetenCenterModels]
--打开一个游标
OPEN MyCursor
--循环一个游标
DECLARE @CenterName nvarchar(64),@CenterID nvarchar(10)
FETCH NEXT FROM MyCursor INTO @CenterName,@CenterID
WHILE @@FETCH_STATUS =0
BEGIN
print 'name'+@CenterName
update [Wcapp_SignInfoStore].[dbo].[Act_CenterDynamic]
set CenterId = @CenterID
where centername = @CenterName
FETCH NEXT FROM MyCursor INTO @CenterName,@CenterID
END
--关闭游标
CLOSE MyCursor
--释放资源
DEALLOCATE MyCursor