sql语句显示复选内容， indication 为复选框的累计value(整数),显示所有的

select *,

(select title as 'data()' from t_DiagnosticReason b where b.type=1 and (a.indication & b.id)>0 for xml path('')) as title

from t_a as a

转载于:https://www.cnblogs.com/y0umer/archive/2012/05/22/3839251.html