ID = @@IDENTITY
insert into Table2 (FieldUsedToJoinToTable1) values (@MyNewID)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bakken, Kory
Sent: Thursday, July 26, 2001 3:07 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] a SQL question
IL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 26, 2001 3:06 PM
Subject: RE: [KCFusion] a SQL question
Can you elaborate on that @@IDENTITY statement?
Can you show me some sample usage? I've never seen that before.
-Original Message-
From: Kenyon Gwillim
Can you elaborate on that @@IDENTITY statement?
Can you show me some sample usage? I've never seen that before.
-Original Message-
From: Kenyon Gwillim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 3:05 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] a SQL question
i
ECTED]'
Subject: RE: [KCFusion] a SQL question
Additionally, remember that if they are all related, and a primary key is
created from the first insert, then you will have to requery the table after
the insert to find the max record id for use in other insert statements.
-Original Message
PROTECTED]]
Sent: Thursday, July 26, 2001 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] a SQL question
yes
wrap them in a transaction block, and commit if they all worked, or rollback
if any failed
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent
yes
wrap them in a transaction block, and commit if they all worked, or rollback
if any failed
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] a SQL question
I need to insert data into
I need to insert data into multiple tables that are
related. Every example of an insert statement I have seen only inserts info into
one table. Do I need to write 4 different INSERT statements?
A.