Isn't that technically multiple queries?
In mysql an insert inserts into one table. That's it.
-Eric
On Wed, 1 Dec 2004 15:50:15 +0100, ***ADI*** <[EMAIL PROTECTED]> wrote:
> in MS SQL u can do it by the following query:
>
> declare @transool varchar(20)
> set @transool = 'opcofficelink'
> b
in MS SQL u can do it by the following query:
declare @transool varchar(20)
set @transool = 'opcofficelink'
begin transaction @transool
insert into Table1 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec,
@Sine_30_Sec)
insert into Table2 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec,
@Sine_30_Se
