Script: Get comma-separated list of columns for table Inb
DECLARE @COLUMN_LIST VARCHAR(MAX) = ''; DECLARE @SCHEMA_NAME VARCHAR(128) = 'dbo'; DECLARE @TABLE_NAME VARCHAR(128) = 'TABLE_NAME_GOES_HERE'; select @COLUMN_LIST=@COLUMN_LIST + COLUMN_NAME + CHAR(13) + CHAR(10) + ',' from information_schema.columns where TABLE_SCHEMA = @SCHEMA_NAME AND TABLE_NAME = @TABLE_NAME -- show column list; remove trailing ',' SELECT 'SELECT ' + CHAR(13) + CHAR(10) + ' ' + SUBSTRING(@COLUMN_LIST, 0, LEN(@COLUMN_LIST)) + 'FROM ' + @SCHEMA_NAME + '.' + @TABLE_NAME DECLARE @COLUMN_LIST VARCHAR(MAX) = ''; DECLARE @SCHEMA_NAME VARCHAR(128) = 'dbo'; DECLARE @TABLE_NAME VARCHAR(128) = 'CAQH_ProviderDirectoryRoster' ; DECLARE @ALIAS_NAME VARCHAR(128) = 'src'; select @COLUMN_LIST=@COLUMN_LIST + COLUMN_NAME + ' = ' + @ALIAS_NAME + '.' + COLUMN_NAME + CHAR(13) + CHAR(10) + ',' from information_schema.columns where TABLE_SCHEMA = @SCHEMA...