Alex Curvers <[EMAIL PROTECTED]> wrote:
>
> Whats the preferred syntax to insert values in multiple (related) tables
> I insert one record, then i need the ID of the inserted value to add it
> the with the other inserts
>
> with MSSQL stored procs its
>
> INSERT INTO ...
Hi All
Whats the preferred syntax to insert values in multiple (related) tables
I insert one record, then i need the ID of the inserted value to add it
the with the other inserts
with MSSQL stored procs its
INSERT INTO .
SELECT @MyID = @@IDENTITY
after that y
