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

来源:互联网 发布:库卡机器人编程软件 编辑:程序博客网 时间:2024/06/03 23:06

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