Listing 2: Using FOR XML PATH to List Indexes' Columns in a Concatenated String

SELECT ',' + c.name AS [text()]
FROM sys.index_columns ic
JOIN sys.columns c ON ic.[object_id] = c.[object_id]
  AND ic.column_id = c.column_id
WHERE ic.[object_id] = OBJECT_ID('SalesLT.Address')
ORDER BY ic.key_ordinal
FOR XML PATH('')