Re: Theory ques: To autogenerate PK or not???????
From: Pierre G. Boutquin <boutquin_at_home.com>
Date: Fri, 13 Oct 2000 12:35:09 GMT
Message-ID: <1kDF5.122543$dZ2.55390039_at_news3.rdc1.on.home.com>
Date: Fri, 13 Oct 2000 12:35:09 GMT
Message-ID: <1kDF5.122543$dZ2.55390039_at_news3.rdc1.on.home.com>
"Heinz Huber" <Heinz.Huber_at_elbanet.co.at> wrote in message
news:39E6A175.94771AA4_at_elbanet.co.at...
> ASA and probably also ASE (since both MSSQL and ASA have it) also use
> _at__at_identity. Just do a "select @@identity" after the insert and it gives
> you the last auto incremented value.
Correct.
I'll add IMMEDIATELY after the insert to this. If needed, store the _at__at_identity value in a temp variable before executing another statement as the _at__at_identity value is typically only guaranteed to be correct immediately after the insert statement.
<Pierre /> Received on Fri Oct 13 2000 - 14:35:09 CEST