Execute the following T-SQL example script in Microsoft SQL Server Management Studio Query Editor to demonstrate the generation of the comma-limited column list - columns name - for a table.

-- SQL information_schema views - database metadata
-- SQL information schema columns - mssql columns name
USE AdventureWorks
 
DECLARE  @Schema  VARCHAR(64),
         @Table   VARCHAR(64),
         @Columns VARCHAR(2000)
 
SET @Table = 'Contact'
SET @Schema = 'Person'
 
-- SQL string append - string concatenation
-- SQL make comma-limited list - make csv list
SELECT   @Columns = COALESCE(@Columns + ', ','') + column_name
FROM     INFORMATION_SCHEMA.Columns
WHERE    table_name = @Table
         AND table_schema = @Schema
ORDER BY ordinal_position
 
-- MSSQL columns list for a table
SELECT @Columns
GO
/*
ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress,
EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo,
rowguid, ModifiedDate

*/

------------