/*Another way to get the fields in comma separated list and store the returned string in a VARCHAR is:*/

DECLARE @TableName SYSNAME = 'tablename'

DECLARE @ColumnNames VARCHAR(MAX)

SELECT @ColumnNames = COALESCE(@ColumnNames + ',','')...