网上查了半天了 实在没办法了 求助各位帮助啊
CREATE PROCEDURE unit_update
@unitId varchar(50) --需要修改的单位id
AS
--修改单位,需要修改人员表中的单位名称(unitNames)字段
-- unit_update '4f319c25-eb7b-440a-9fb0-87f006bbc5a9' --使用游标遍历所有需要修改的数据
declare my_cursor cursor
for
select users from freecms_unit_user where unit =@unitId
open my_cursor
declare @userId nvarchar(50)
fetch next from my_cursor into @userId
while(@@fetch_status=0)
begin
--组合此用户现在的单位名称
declare unitName_cursor cursor
for
select name from freecms_unit where id in (select unit from freecms_unit_user where users =@userId)
open unitName_cursor
declare @unitNames nvarchar(500)
set @unitNames=''
declare @unitName nvarchar(50)
fetch next from unitName_cursor into @unitName
while(@@fetch_status=0)
begin
--组合此用户现在的单位名称
set @unitNames = @unitNames + @unitName+';'
fetch next from unitName_cursor into @unitName
end close unitName_cursor
deallocate unitName_cursor --更新人员表中的unitNames字段
update freecms_users set unitNames=@unitNames where id=@userId
fetch next from my_cursor into @userId
endclose my_cursor
deallocate my_cursor
GO
CREATE PROCEDURE unit_update
@unitId varchar(50) --需要修改的单位id
AS
--修改单位,需要修改人员表中的单位名称(unitNames)字段
-- unit_update '4f319c25-eb7b-440a-9fb0-87f006bbc5a9' --使用游标遍历所有需要修改的数据
declare my_cursor cursor
for
select users from freecms_unit_user where unit =@unitId
open my_cursor
declare @userId nvarchar(50)
fetch next from my_cursor into @userId
while(@@fetch_status=0)
begin
--组合此用户现在的单位名称
declare unitName_cursor cursor
for
select name from freecms_unit where id in (select unit from freecms_unit_user where users =@userId)
open unitName_cursor
declare @unitNames nvarchar(500)
set @unitNames=''
declare @unitName nvarchar(50)
fetch next from unitName_cursor into @unitName
while(@@fetch_status=0)
begin
--组合此用户现在的单位名称
set @unitNames = @unitNames + @unitName+';'
fetch next from unitName_cursor into @unitName
end close unitName_cursor
deallocate unitName_cursor --更新人员表中的unitNames字段
update freecms_users set unitNames=@unitNames where id=@userId
fetch next from my_cursor into @userId
endclose my_cursor
deallocate my_cursor
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货