title: How to get all column names without one column in sql table in SQL Server
body: <p>How to get all column names without one column in sql table in  SQL Server.</p>
  
  <p>I have a temp table. It has columns:  </p>
  
  <pre><code>ID, Status, Code, Name, Location, Address, Title, Category, Line, date, time, UserName
  </code></pre>
  
  <p>I want all data without the <code>id</code> column </p>
  
  <p>I want an alternative to this SQL code for this</p>
  
  <pre><code>SELECT Status, Code, Name, Location, Address, Title, Category, Line, date, time, UserName 
  FROM TEMP
  </code></pre>