SELECTING IDENTITY VALUES

[SHERYL KEMP]

How can I select the identity values from 2 seperate tables?
what is the syntax please

[David Satz]

there is really no such thing:

declare @id1 int, @id2 int

insert table1 ( ..) values (...)
set @id1 = scope_identity() -- @@identity prior to SQL Server 2000

insert table2 ( ..) values (...)
set @id2 = scope_identity() -- @@identity prior to SQL Server 2000
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"SHERYL KEMP" <DIANEDINERO@AOL.COM> wrote in message
news:3c98e7f6$1@10.1.10.29...
>
> How can I select the identity values from 2 seperate tables?
> what is the syntax please