title: What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
body: <p>I know <code>Scope_Identity()</code>, <code>Identity()</code>, <code>@@Identity</code>, and <code>Ident_Current()</code> all get the value of the identity column, but I would love to know the difference.</p>
  
  <p>Part of the controversy I'm having is what do they mean by scope as applied to these functions above?</p>
  
  <p>I would also love a simple example of different scenarios of using them?</p>