title: Modify int result of count in sql server 2005
body: <p>I am working on sql server 2005 and I am taking count from a specific table</p>
  
  <pre><code>SELECT count(StudentIdReference) as studentCount FROM StudentTable
  </code></pre>
  
  <p>Right now this select statement is returning me result like 2 or 78 or 790. But in future it will grow rapidly and on UI I don't have sufficient space to show the digit like 1000000. 
  What I want that after 3 digit, I will get the number like 1K or 1.6K, just as we see on stackoverflow.</p>