Using T-SQL to get comma separated list of all columns in a table

by Joe Hunter 4. March 2010 09:26

DECLARE @listOfColumns VARCHAR(MAX)

 

SET @listOfColumns = ( SELECT TOP 1

STUFF( (SELECT ', ' + T2.COLUMN_NAME

          FROM INFORMATION_SCHEMA.COLUMNS AS T2

          WHERE T2.TABLE_NAME = T1.TABLE_NAME

            FOR XML PATH('')), 1, 2, '') AS COL_NAMES

FROM INFORMATION_SCHEMA.COLUMNS AS T1

WHERE T1.TABLE_NAME = 'MAIN'

ORDER BY T1.ORDINAL_POSITION)

 

PRINT @listOfColumns

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen