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 titlefrom t_a as a