• try this

    declare @sql varchar(max)

    select @sql=coalesce(@sql,'')+columnname

    from

    tablename

    select @sql