SQL中如何向两个表中同时插入数据
SQL中如何向两个表中同时插入数据,一个是主表,一个是明细表
代码如下:
if exists(select * from sysobjects where type='U' and name='ls1' )
drop table ls1
CREATE TAbLE ls1
( lFBillNo nvarchar(510),
lFDate1 datetime,
lFNumber varchar(80),
lfname varchar(255),
lfmodel varchar(255),
lfqty decimal(13),
lfprice decimal(13),
lfdate2 datetime)
insert into ls1(lFBillNo,lFDate1,lFNumber,lfname,lfmodel,lfqty,lfprice ,lfdate2)
values('1.001.001','2015-08-06','1.001.001','华硕品牌电脑','','60','2600','2015-09-30')
insert into (select fbillno,se.fdate,t.fnumber,t.fname,
fmodel,fqty,fprice,famount,SED.fdate from SEOrderEntry SED
left join t_item t on t.fitemid=SED.fitemid left join t_icitem ti
on ti.fitemid=t.fitemid left join SEOrder SE on SE.Finterid=SED.Finterid)g
select * from ls1
此代码实现不了,求高手指点