zwm520lj的专栏

create proc testasSELECT id=IDENTITY(int,1,1),ClassName                   INTO #T_Temp0                   FROM dbo.G_News_Class                 ORDER BY AutoIDSELECT   *   FROM   #T_Temp0        

之前是这种效果，要变成这种效果select b.id,left(userlist,len(userlist)-1) as paths from(select id,(select userid+',' from test2 where id=a.id order by id for xml path('')) as userlistfrom test2 agro