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
Original issue reported on code.google.com by
cow...@bbs.darktech.org
on 22 Sep 2014 at 9:34