Re: Atomicity of using IDENTITY_VAL_LOCAL()

[Paul J. Lucas]

On Fri, 13 May 2005, Mamta Satoor wrote:
The SELECT IDENTITY_VAL_LOCAL() FROM mytable1 will return the value that got
into generated for *any* table with identity column using single row insert
with values clause in the current transaction.
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^
        That nugget of information is not in the documentation I don't
        believe.  So that implies that if there are two open
        transactions in two different threads and each does an insert,
        then each thread will get its respective "correct" value for
        IDENTITY_VAL_LOCAL().
        Right?
	- Paul