|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Insert DataI need to insert data from one table into multiple tables. I understand how
to insert the data by coding to insert statements. However is it possible to do one insert statement into two tables (I do want to select the data twice)? Thanks No, one INSERT can only target one table. You will have to select the
data for each INSERT. Roy Harvey Beacon Falls, CT Show quote On Fri, 4 Aug 2006 12:40:26 -0600, "Bob" <rob***@bob.com> wrote: >I need to insert data from one table into multiple tables. I understand how >to insert the data by coding to insert statements. However is it possible >to do one insert statement into two tables (I do want to select the data >twice)? > >Thanks > Bob,
Directly: no. Why do you need it? Anyway, read on INSTEAD OF triggers as a way around.  |
|||||||||||||||||||||||
Other interesting topics