>few answers in the list archives.
I usually do search the archives first, but in this case I wasn't sure what to search on.
I'll have to re-read the answer below a few more times. Thanks for the help. I thought there was an @ thing.
>However, to summarize, you can select the newly generated identity value in
>another query, or you can attach a trigger to the table that returns the
>identity when a record is inserted, or you can write a stored procedure that
>performs both the insert and the selection of the new identity, or you may
>be able to perform both within a single SQL batch depending on your
>platform.
>
>If you're using SQL Server, for instance, you can use @@IDENTITY (or
>SCOPE_IDENTITY in newer versions) to refer to the new identity column value.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
