select manages from tables
declare @i int
set @i=1
while @i < (select count(*) from tables)
begin
update tablesset manages =(select manages from tableswhere companyid=@i)+','
break
set @i=@i+1
end
更多信息请查看IT技术专栏