If you ever do work on a system where identities are used and you rely on @@Identity, you could get some very unusual results at some point in the future when someone adds an auditing trigger. It's not a deal breaker question, but it's an interesting one to lead them into a conversation about dealing with related tables.
To get more details regarding this issue, read from here.
This is a blog with a collection of internet articles on various topics that I find useful.
No comments:
Post a Comment