Articles related "SQL concatenation"

There is frequent need for sql string concatenation to get a list of column values(Comma separated value) of a table. Generally udf's (Used Defined Function) are used to concatenate string in sql. Here is a very simple T-SQL sample using FOR XML PATH() in order concatenate strings values in SQL SERVER