title: why does SELECT SCOPE_IDENTITY() return null?
body: <p>in what case does <code>SELECT SCOPE_IDENTITY()</code> return null?</p>
  
  <p>i am doing this:</p>
  
  <pre><code>Set rs = cn.Execute("SELECT SCOPE_IDENTITY()", , adCmdText)
  capture_id = rs.Fields(0)
  </code></pre>
  
  <p>and i getting <code>capture_id=null</code></p>