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

[y_zhi_yong]

我在查询解释器中运行如下语句,
begin transaction
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
go
但是在关闭该语句的窗口时提示事务没有提交.而且,我新开的窗口查询表tem_saleplan_main时也一直处在等待状态.

请问,事务如何提交?

[caiyunxia]

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

[leimin]

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

[pengdali]

try:

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

[pengdali]

or:

SET LOCK_TIMEOUT 3000