sql语句

select cast((select cast(gd.GradeName as varchar(20))+',' from Sys_GradeData as gd where exists(select 1 from [dbo].[f_split](p.gradecode,',') s where s.col=gd.Id) for xml path('')) as varchar(100) ) as BookVersion  from TB_Paper_Papers as p

原文地址:https://www.cnblogs.com/weiying/p/weiying_2017_09_18.html