db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Boynes <jboy...@apache.org>
Subject Re: Atomicity of using IDENTITY_VAL_LOCAL()
Date Sat, 14 May 2005 16:15:39 GMT
Mamta Satoor wrote:
> Hi Jeremy,
>  I tried a simple test to see what happens in the case you brought up. The 
> value retruned by IDENTITY_VAL_LOCAL is from the statement's table (and not 
> from the table which got modified by the trigger).


As a cross-reference, this the behaviour of MS SQL Server 2000's 
SCOPE_IDENTITY() function and not the older @@IDENTITY one.


View raw message