Generate SELECT SQL with listing all columns in the table (SQL Server)

select.sql

-- for one table
SELECT 'SELECT ' + STUFF((
    SELECT ', ' + name + CHAR(10)
    FROM sys.columns
    WHERE object_id = OBJECT_ID('table_name')
    FOR XML PATH('')
), 1, 2, '') + ' FROM table_name;';

-- if you want to generate such SQL for multiple tables:
SELECT (SELECT 'SELECT ' + STUFF((SELECT ', ' + name + CHAR(10)
                                  FROM sys.columns
                                  WHERE object_id = OBJECT_ID(table_name)
                                  FOR XML PATH('')), 1, 2, '') + ' FROM ' + table_name + ';')
  FROM (VALUES ('table_a'),
               ('table_b'),
               ('table_c'),
               ('table_d'),
               ('table_e')) AS t(table_name);