Group_concat MySQL function's equivalent in MS-SQL SERVER

Question

I am looking for a function same GROUP_CONCAT of mysql in T-SQL(SQL SERVER) or some functionality

score 0 · Accepted Answer · answered Jul 24 '14 at 10:29

0

We don't have such group_concat of mysql in sql server, either you can use Stuff function or for xml path functionality to achiev

answered Jul 24 '14 at 10:29

Bhimisetty

here is a **STUFF** based sample: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f09d4166-2030-41fe-b86e-392fbc94db53/tsql-equivalent-for-groupconcat-function – Alessandro Alpi Jul 24 '14 at 13:06
thanks @AlessandroAlpi. – MajidTaheri Aug 22 '14 at 15:50

1 Answers1