"quite amusing and drastically geeky at the same time"
Note to self, always use SELECT SCOPE_IDENTITY() instead of SELECT @@IDENTITY. I knew this already but always forget which one I should be using.
I remember using IDENT_CURRENT http://msdn2.microsoft.com/en-us/library/ms175098.aspx instead of SCOPE_IDENTITY() because of lack of knowledge. It was live multi-user system I developed (http://www.cwwg.org/as01.24.03.html), and my mistake was discovered after part of the data of one user was added to another user... I was be able to find my error during the day...
Thanks for the info, I wasn't even aware of IDENT_CURRENT! I'm sure that and @@IDENTITY probably have their uses, but I'm guessing SCOPE_IDENTITY() is the one to use 99% of the time
Post a Comment