SQL SERVER STUFF 字段拼接成一行

--用法如图 已, 分割 ''内存放数据 
  select    STUFF((SELECT ',' + '"' + ISNULL(mtl_no,'') + '"'         
          FROM SL_LOT_MTL_CHG_SUM_ITEM WITH(NOLOCK) WHERE doccode  = '1513000003' FOR XML PATH('')),1,1,'')        



          select *from SL_LOT_MTL_CHG_SUM_ITEM WHERE doccode  = '1513000003'
        

按照某一字段 拼接 字符串

--用法如图 已, 分割 ''内存放数据   
select refCodeitem,    STUFF((SELECT ',' + '"' + ISNULL(ItemType,'') + '"'         
          FROM imatdocitem  a WHERE c.refCodeitem=a.refCodeitem and DocCode='SR00013214'
         
          FOR XML PATH('')),1,1,''
           
          )    as nc    
        from imatdocitem c   where  c.DocCode='SR00013214'

        group by c.refCodeitem

 

 很好用