sql随机排序与sql多行合并成一行与sql排序之后取其中特定一条数据

declare @n int
declare @maxLen int
select @maxLen=COUNT(1) from dbo.T_CGame_List
set @n=1
while @n<=@maxLen
BEGIN
UPDATE dbo.T_CGame_List SET GameVersionDesc=(SELECT
STUFF(
(SELECT top 5 ',' + name FROM [T_CGame_ContentTag] order by NEWID() FOR xml path('')),1,1,'')
)
WHERE ID= (
select ID from ( select row_number() over ( order by ID asc) as rownum,* from T_CGame_List ) a
where rownum =@n
)

set @n=@n+1
end

时间有限，晚点详细解释一下