title: HOW do i use SELECT @@identity in sql server?
body: <p>i am currently calling SELECT @@identity from VBA in mysql:</p>
  
  <pre><code>Set rs = cn.Execute("SELECT @@identity", , adCmdText)
  </code></pre>
  
  <p>but since i am going to be working with sql server db instead of mysql, i would like to know how to  make this statement sql-server friendly</p>
  
  <p>would it just be <code>Set rs = cn.Execute("SCOPE_IDENTITY()", , adCmdText)</code> ??</p>