--把一列合并成成一个字段并用逗号分隔
select stuff((select ','+UsersPhoneId from BusinessUserInfo where LEN(UsersPhoneId)>0 for xml path('')),1,1,'')as UsersPhoneId
--把一列合并成成一个字段并用逗号分隔
select stuff((select ','+UsersPhoneId from BusinessUserInfo where LEN(UsersPhoneId)>0 for xml path('')),1,1,'')as UsersPhoneId
![那些奇葩的辞职理由！程序员“要命不要钱”最心酸[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)