title: How to auto-complete all columns in "select * from table" in SQL Server Management Studio
body: <p>Write this: </p>
  
  <pre><code>    Select      *         From tablea
  </code></pre>
  
  <p>Want this:</p>
  
  <pre><code>    Select c1, c2, c3 ... From tablea
  </code></pre>
  
  <p>SQL Server Management Studio provides intellisense to pick one column at a time. It takes a while for table with lots of columns. </p>
  
  <p>I can use Script Table as =>Select To=> New Query Edit Window, and the copy/paste to my original script. however is there a less interruptive way?</p>
  
  <p>I write SQL a lots, thanks for help!</p>