title: Will SCOPE_IDENTITY Work in this Case?
body: <p>I have PK that is self incrementing key. I need to insert the record into the database and then get that PK back and use it in another insert.</p>
  
  <p>However I would like to do this in one transaction. Is that possible. The idea is that if something fails in any of the updates/inserts I have to do then I can rollback everything but I am under the impression that I need to do a commit.</p>
  
  <p>I was going to do it in ado.net at first but then switched to a stored procedure since I thought maybe that would get around this issue.</p>
  
  <p>Will a SP help me out in this case?</p>