title: Table alias not working on sql server 2012
body: <p>My table alias is not working on SQL server 2012. I have enabled Intellisense.
  Still it's not working.</p>
  
  <p><code>select * from department a</code> -- Alias <code>a</code> should taken all columns automatically when I write:</p>
  
  <pre><code>select *
    from department a
   where a.departmentid = .. 
  </code></pre>
  
  <p><code>departmentid</code> column have to come automatically when I write <code>a</code>.</p>
  
  <p>Is there any setting I need to change in my server?</p>