• For select dthe columns without remove last comma

    SELECT TOP 10 @columnName = COALESCE(@columnName + ',' + QUOTENAME(COLUMN_NAME), QUOTENAME(COLUMN_NAME))

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = @tableName

    AND TABLE_SCHEMA = 'DBO'

    ORDER BY ORDINAL_POSITION ASC