摘要:
SQL 将一列数据转化为字符串SELECTDISTINCTu1.[ItemCode],REPLACE((SELECTu2.[DetailDescription]+','AS'data()'FROM[YinTaiContent].[dbo].ItemProfileDetailsu2WHEREu2.[ItemCode]=u1.[ItemCode]FORXMLPATH(''))+'$',',$','')ASRolesFROM[dbo].ItemProfileDetailsu1WHEREu1.ItemCod 阅读全文