函數(shù)

stuff(param1, startIndex, length, param2)函數(shù)說明將param1中自startIndex(SQL中都是從1開始，而非0)起，刪除length個(gè)字符，然后用param2替換刪掉的字符。例子

我有個(gè)#tmp1 的表，內(nèi)容為

執(zhí)行下面語(yǔ)句

SELECT PRODID,KTL_CustRef, PO = stuff ((SELECT ' ' + PO FROM  #tmp1 AS t WHERE   t .PRODID = tb.PRODID FOR xml path('')), 1, 1, '')FROM   #tmp1 tbGROUP BY PRODID,KTL_CustRef

結(jié)果為