The ability to implement GROUP_CONCAT functions similar to MySQL in SQL Server

SQL Server does not have a group_concat function in MySQL that can connect grouped data together.

After the search on the internet, found a way to implement this function, hereby recorded.

Selecta,stuff ((SELECT ', ' + b from #tb WHERE a = t.a FOR XML Path (")), ("), ") as B from # TB as Tgroup bya;

First Group A column, the group of B in the form of XML output, and then use the stuff switch out, delete.

Specific implementation reference: http://blog.itnmg.net/sqlserver-group_concat/

For the FOR XML Path reference http://www.cnblogs.com/doubleliang/archive/2011/07/06/2098775.html that is actually used

Stuff Reference Http://msdn.microsoft.com/zh-cn/library/ms188043.aspx

The ability to implement GROUP_CONCAT functions similar to MySQL in SQL Server