Binaryworld - How to return column list of a specific table using XML XPATH query te ... [ SQL Server -> SQL-XML ]

The following code snippet will produce comma seperated list of column name of a specified table from Northwind Database.

Click here to copy the following block

DECLARE @tblName VARCHAR(100)
SET @tblName = 'Northwind.dbo.Customers'
-- Or --
-- SET @tblName = 'Customers'

  SELECT
      Stuff
      (
         (
            SELECT
               N', ' + name
            FROM
                 sys.columns pc
            WHERE pc.object_id = OBJECT_ID(@tblName)
            FOR XML PATH(''),TYPE
         ).value('text()[1]','nvarchar(max)'),1,2,N''
      ) AS ColumnList

Returns The following output

Click here to copy the following block

ColumnList
---------------
CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax