tag:blogger.com,1999:blog-19519354.post1743309074511462874..comments2023-06-30T13:58:14.439+01:00Comments on Doogal Bell's bloggy thing: SCOPE_IDENTITY() and @@IDENTITYDoogalhttp://www.blogger.com/profile/17764319095707998627noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-19519354.post-73274872571027337642008-04-17T21:39:00.000+01:002008-04-17T21:39:00.000+01:00Thanks for the info, I wasn't even aware of IDENT_...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 timeDoogalhttps://www.blogger.com/profile/17764319095707998627noreply@blogger.comtag:blogger.com,1999:blog-19519354.post-77894445291678501962008-04-11T23:25:00.000+01:002008-04-11T23:25:00.000+01:00I remember using IDENT_CURRENT http://msdn2.micros...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...Владимирhttps://www.blogger.com/profile/00331194583266302228noreply@blogger.com