是这样的效果么?
insert into b(sno,sname,ssex) select sno,sname,ssex from a
insert into c(sco,sscore) select sco,sscore from a
insert into b(sno,sname,ssex) select sno,sname,ssex from a
insert into c(sco,sscore) select sco,sscore from a
INSERT C(Sco,Sscore) SELECT Sco,Sscore FROM A
as
insert b(sno,sname,ssex) select sno,sname,sex from a
insert c(sco,ssocore) select sco,sscore from a这个可不可以呢????
as
begin tran
insert b(sno,sname,ssex) select sno,sname,sex from a
if @@errcode <> 0 then goto Exception
insert c(sco,ssocore) select sco,sscore from a
if @@errcode <> 0 then goto Exception
commitException:
rollback tran