SQL SERVER FOR XML PATH合并字串

標籤：

兩種方式,效率立竿見影

------------------------------------------------SET STATISTICS TIME ONDECLARE  @OrderStr  NVARCHAR(max) = ‘‘;SELECT @OrderStr += a.SerialNumber+‘,‘FROM dbo.WithdrawalsLog aSET STATISTICS TIME OFF------------------------------------------------SET STATISTICS TIME ONDECLARE  @OrderStr  NVARCHAR(max) = ‘‘;SET @OrderStr = (SELECT a.SerialNumber+‘,‘FROM dbo.WithdrawalsLog aFOR XML PATH(‘‘))SET STATISTICS TIME OFF------------------------------------------------

 

如果要擷取某個表的欄位,並把它拼接成一個字串,那這個方法再好不過了:SELECT bankcode+‘,‘+bankname+‘;‘   FROM BankInfo FOR XML PATH(‘‘)

 

 

懶得寫了,看不懂的看這裡: 

http://www.cnblogs.com/doubleliang/archive/2011/07/06/2098775.html

 

SQL SERVER FOR XML PATH合并字串