![Why should I use CONCAT when SQL Server can concatenate using + ? | Learn SQL With BruLearn SQL With Bru Why should I use CONCAT when SQL Server can concatenate using + ? | Learn SQL With BruLearn SQL With Bru](http://learnsqlwithbru.com/wp-content/uploads/2011/12/Why_Use_CONCAT1.png)
Why should I use CONCAT when SQL Server can concatenate using + ? | Learn SQL With BruLearn SQL With Bru
![Concatenate rows values as a comma separated string using FOR XML PATH and STUFF in SQL SERVER ~ Asp.Net,C#.Net,VB.Net,MVC,jQuery,JavaScipt,AJAX,WCF,Sql Server example Concatenate rows values as a comma separated string using FOR XML PATH and STUFF in SQL SERVER ~ Asp.Net,C#.Net,VB.Net,MVC,jQuery,JavaScipt,AJAX,WCF,Sql Server example](https://4.bp.blogspot.com/-ZG1at_BVDP0/Vo1tMvzJQsI/AAAAAAAA_jM/5ali3j8r3UU/s1600/Concatenate%2Brows%2Bvalues%2Bas%2Ba%2Bcomma%2Bseparated%2Bstring%2Busing%2BFOR%2BXML%2BPATH%2Band%2BSTUFF%2Bin%2BSQL%2BSERVER.png)
Concatenate rows values as a comma separated string using FOR XML PATH and STUFF in SQL SERVER ~ Asp.Net,C#.Net,VB.Net,MVC,jQuery,JavaScipt,AJAX,WCF,Sql Server example
![SQL Server - How to concatenate rows by grouping data by one column (Grouped concatenation) - Dirceu Resende SQL Server - How to concatenate rows by grouping data by one column (Grouped concatenation) - Dirceu Resende](https://www.dirceuresende.com/wp-content/uploads/2016/06/SQL-Server-Grouped-Concatenation-convert-rows-into-string.png)
SQL Server - How to concatenate rows by grouping data by one column (Grouped concatenation) - Dirceu Resende
![SQL Server - How to concatenate rows by grouping data by one column (Grouped concatenation) - Dirceu Resende SQL Server - How to concatenate rows by grouping data by one column (Grouped concatenation) - Dirceu Resende](https://www.dirceuresende.com/wp-content/uploads/2016/06/SQL-Server-Grouped-Concatenation-convert-rows-into-string-Performance-STUFF-FOR-XML-PATH4.png)