表Blog的BlogTypeIDList字段记录了对应的以逗号间隔的BlogTypeID字符串(类似“2,6,8”的形式),
读取每行blog对应的多行blogtype记录的语句如下:
select
b.blogid,stuff(bt.btn.value('/BT[1]','nvarchar(max)'),1,1,'')
from
blog b
cross apply
(select btn=(select N','+blogtypename from blogtype where ','+cast(b.blogtypeidlist as varchar)+',' like '%,'+cast(blogtypeid as varchar)+',%' For XML PATH(''), ROOT('BT'), TYPE))bt
用到了croos apply 和 xml