3 ms·
> This is just one example of the nonsense you have to put up with on SQL Server, there are many others. The equivalent of GROUP_CONCAT in MySQL or STRING_AGG
by kbenson 10y ago
> This is just one example of the nonsense you have to put up with on SQL Server, there are many others.
The equivalent of GROUP_CONCAT in MySQL or STRING_AGG in Postgres in MSSQL is ridiculous. Yes, I understand it's more versatile and extensible to use a subselect which can be mostly optimized away, output as XML, prefix each field with your delimiter, and then ignore the first character of the concatenation of those fields, but come on[1]. Throw your users a bone once in a while...
1: http://stackoverflow.com/a/5981860/210749 http://stackoverflow.com/a/5981860/210749
- mistermann 10y agoFrom that post: "Or a version that works correctly if the data might contain characters such as <" What other edge cases are you missing? Do you care? Microsoft certainly doesn't. TSQL is an embarrassment, it is a perfect example of the arrogance of Microsoft that is luckily finally being corrected on many teams (C#, Azure) but persists in the MSSQL camp.