SET resets SCOPE_IDENTITY()

shaa108 / h2database

Automatically exported from code.google.com/p/h2database

1 stars 0 forks source link

SET resets SCOPE_IDENTITY() #585

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago

As Thomas described a few years ago, SET resets the value of SCOPE_IDENTITY(): 
http://stackoverflow.com/a/12319823/14731

Expected behavior: SET should not reset SCOPE_IDENTITY().

Original issue reported on code.google.com by cow...@bbs.darktech.org on 22 Sep 2014 at 9:34