title: Overwrite ONE column in select statement with a fixed value without listing all columns
body: <p>I have a number of tables with a large number of columns (> 100) in a SQL Server database. In some cases when selecting (using views) I need to replace exactly ONE of the columns with a fixed result value instead of the data from the row(s).
  Is there a way to use something like </p>
  
  <pre><code>select table.*, 'value' as Column1 from table
  </code></pre>
  
  <p>if Column1 is a column name within the table?</p>
  
  <p>Of course I can list all the columns which are expected as result in the select Statement, replacing the one with a value.
  However, this is very inconvinient and having 3 or 4 those views I have to maintain them all if columns are added or removed from the table.</p>