select d.agentid,d.startdate,storeamount from (select * from dbo.tbmain union all select 0,'2003-4-1',1,'列数要和tbmain一样'......) m,dbo.tbdetail d.mainid=m.mainid and d where m.issent=1 ???
set identity_insert tbmain on insert into tbmain values (0,'2003-4-1','1'...) set identity_insert tbmain offselect d.agentid, d.startdate, m.storeamount from dbo.tbmain m, dbo.tbdetail d where d.mainid = m.mainid and m.issent=1delete tbmain where mainid = 0 ------若只是临时,可以删除。
insert into tbmain values (0,'2003-4-1','1'...)
set identity_insert tbmain offselect d.agentid, d.startdate, m.storeamount
from dbo.tbmain m, dbo.tbdetail d
where d.mainid = m.mainid and m.issent=1delete tbmain where mainid = 0 ------若只是临时,可以删除。