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

posted on 2017-09-18 13:59  hehedada  阅读(83)  评论(0编辑  收藏  举报

导航