title: GUID. and automatic id as primary key in SQL databases
body: <pre><code>SELECT COUNT(*) FROM table_name;
  </code></pre>
  
  <p>My algorithm is:</p>
  
  <ul>
  <li>check count  </li>
  <li>count+1 is the new primary key starting point  </li>
  <li>Then keep on incrementing before every insert operation</li>
  </ul>
  
  <p>But what is this GUID? Does SQL Server provide something where it automatically generates and incremented primary key?</p>