如下事务处理为何不能提交?烦请各位

Question

begin transaction
insert into tem_saleplan_main(cdepcode,cpersoncode,pdate,cchecker,cdate,pflag,mem)
values('0101','yzy','2003-5-24','','',0,'');
commit transaction

Answer 1

begin transaction test
select max(id) from tem_saleplan_main with (tablockx) 
insert into tem_saleplan_main(cdepcode,cpersoncode,pdate,cchecker,cdate,pflag,mem)
values('0101','yzy','2003-5-24','','',0,'')
commit transaction test

Answer 2

try:SET TRANSACTION ISOLATION LEVEL READ COMMITTED