SQL SERVER for XML path merge string

Two ways, efficiency is immediate

------------------------------------------------SET STATISTICSTime onDECLARE  @OrderStr  NVARCHAR(Max)= "';SELECT @OrderStr +=A.serialnumber+',' fromdbo. Withdrawalslog aSET STATISTICSTimeOFF------------------------------------------------SET STATISTICSTime onDECLARE  @OrderStr  NVARCHAR(Max)= "';SET @OrderStr = (SELECTA.serialnumber+',' fromdbo. Withdrawalslog a forXML PATH ("'))SET STATISTICSTimeOFF------------------------------------------------

If you want to get a table field and stitch it up into a string, that's a good way to do it: SELECT bankcode+','+bankname+'; '    from  for XML PATH (")

Too lazy to write, can not understand the look here:

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

SQL SERVER for XML path merge string