将一列数据拼接成一个字符串

 SELECT STUFF( 
 (SELECT 
  Distinct '|'+ProductCode 
  FROM [chexian].[dbo].[ProxyServer] 
  WHERE CompanyID=1069 FOR XML PATH('')
 ),1,1,'')