title: What does "Is Identity" column property mean in SQL Server?
body: <p>I am using <strong>SQL Server</strong> for the first time and I see that a column property is called <strong>Is Identity</strong>.</p>
  
  <p>What does this mean?</p>
  
  <p>What are the advantages of marking a column property as <strong>Is Identity = Yes</strong>?</p>