title: What is the difference between scope_identity() and current_identity()?
body: <pre><code>What is the difference between scope_identity() and current_identity()?
  </code></pre>
  
  <p>Scope_identity and current _identity both are similar and it will return the last identity     value generated in the table.
    Scope_Identity will return the identity value in table that is currently in scope</p>
  
  <p>is it correct definition for this question?</p>