Cacher is the code snippet organizer for pro developers

DECLARE @SQL    nvarchar(4000) = ''
 
-- get all column names of table Target_Table, separated by commas
SELECT @SQL += COLUMN_NAME + ', ' FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Target_Table'
 
-- remove last comma
SELECT LEFT(@SQL, len(@SQL) - 2)