BSW.Blog

Fast Way To Convert A Column to CSV.

Select replace	(
					(
					select name+','  from sys.databases  
						for xml path ('')
					)+',',',,',''
				) 

Result:

master,tempdb,model,msdb,Customers,ExternalDB