BEGIN TRAN TranInsert[Insert Statement1] [Insert Statement2] ...COMMIT TRAN TranInsert
create proc yy as insert into tabelA(col1,col2) values('asdf','123') insert into tabelB(col1,col2) values('ghj','456') -----------------------------------------------------
create proc abcd @aa char(10), @bb int as insert into abc values(@aa,@bb) insert into cba values(@aa,@bb) begin tran if exists(select * from abc where aa=@aa) and exists(select * from cba where aa=@aa) begin print 'ok' commit tran end else begin print'sorroy you record is not inserted' rollback tran end ================俺什么都不懂,做的也许不对===================(所影响的行数为 1 行) (所影响的行数为 1 行)ok
CREATE OR REPLACE procedure ml_add_insertscript is begin ml_add_table_script ('d1','xlxjt_xjjh','upload_insert','INSERT INTO xlxjt_xjjh(jhbm,jhmc,jhlb,qsrq,zzrq,jhjc,fpbs,txyy,bzr,bzrgh,bzrq,bmbh) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)'); ml_add_table_script ('d1','xlxjt_xljh','upload_insert','INSERT INTO xlxjt_xljh(jhbm,xlbm,xlmc,sfwc,sfyc) VALUES(?,?,?,?,?)'); ml_add_table_script ('d1','xlxjt_gtjh','upload_insert','INSERT INTO xlxjt_gtjh(jhbm,gtbm,bzbh,bzmc,xjrwbh,sfwc,sfyc,sftg,gtdh,xjry,xjfs,jd,wd,xsjd,xswd,gtmc,xlbm,xjsj) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');commit; end; /
用事务处理最方便了 SET NOCOUNT ON BEGIN TRAN 在此写插入SQL语句 COMMIT TRAN SET NOCOUNT OFF
[Insert Statement2]
...COMMIT TRAN TranInsert
as
insert into tabelA(col1,col2) values('asdf','123')
insert into tabelB(col1,col2) values('ghj','456')
-----------------------------------------------------
@aa char(10),
@bb int
as
insert into abc values(@aa,@bb)
insert into cba values(@aa,@bb)
begin tran
if exists(select * from abc where aa=@aa) and exists(select * from cba where aa=@aa)
begin
print 'ok'
commit tran
end
else
begin
print'sorroy you record is not inserted'
rollback tran
end
================俺什么都不懂,做的也许不对===================(所影响的行数为 1 行)
(所影响的行数为 1 行)ok
is
begin
ml_add_table_script ('d1','xlxjt_xjjh','upload_insert','INSERT INTO xlxjt_xjjh(jhbm,jhmc,jhlb,qsrq,zzrq,jhjc,fpbs,txyy,bzr,bzrgh,bzrq,bmbh) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)');
ml_add_table_script ('d1','xlxjt_xljh','upload_insert','INSERT INTO xlxjt_xljh(jhbm,xlbm,xlmc,sfwc,sfyc) VALUES(?,?,?,?,?)');
ml_add_table_script ('d1','xlxjt_gtjh','upload_insert','INSERT INTO xlxjt_gtjh(jhbm,gtbm,bzbh,bzmc,xjrwbh,sfwc,sfyc,sftg,gtdh,xjry,xjfs,jd,wd,xsjd,xswd,gtmc,xlbm,xjsj) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');commit;
end;
/
SET NOCOUNT ON
BEGIN TRAN
在此写插入SQL语句
COMMIT TRAN
SET NOCOUNT OFF