This Query Gives all columns in a single column Separated with comma.
SELECT STUFF((SELECT COLUMN_NAME+',' as [text()] FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TableName' for xml path('')),1,0,'')
You can Replace the comma with any symbol by which u want to separate.
'TableName' must be replaced by your table name.
