The SQL Server 2012 CONCAT function accepts two or more string values. The user-defined CONCAT function accepts only two values. It's the "two or more" part that would...

The reason the script is not revolutionary is because other like Erland Sommarskog performed a lot of testing to figure out the best way to do it (http://www.sommarskog.se/arrays-in-sql-2005.html). In...

A comma-delimited list of values can also be generated using the for xml path approach.

select stuff((select ',' + cast(sNumber as varchar(10))

from @demo

for xml path('')),1,1,'');