sql server应用——取消存储过程执行注意回滚

最近在处理一个大数据量表数据清理任务，通过存储过程实现单次10w行记录的清理，通过go循环实现循环执行。

以下是演示的存储过程：

select * into test_BD_ACCOUNT from T_BD_ACCOUNT 
create proc Proc_BF_test
as
begin
 begin try
 begin transaction
waitfor delay '00:00:02:00'
insert into test_BD_ACCOUNT(FACCTID,FNUMBER,FPARENTID,FHELPERCODE,FGROUPID,FDC,FACCTTBLID,FISCASH,FISBANK,FISALLOCATE,FISCASHFLOW,FITEMDETAILID,FISQUANTITIES,FUNITGROUPID,FUNITID,FISDETAIL,FLEVEL,FCREATEORGID,FCREATORID,FCREATEDATE,FUSEORGID,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDSTATUS,FFORBIDDERID,FFORBIDDATE,FMASTERID,FISSYSPRESET,FDOCUMENTSTATUS,FCFItemID,FCFINDIRECTITEMID,FOCFITEMID,FOCFINDIRECTITEMID,FALLCURRENCY,FCURRENCYLIST,FCURRENCYS,FCONTROLORGID,FISSHOWJOURNAL,FAMOUNTDC,FISCONTACT,FUNMANUAL,FISINTERNALCONTACTS,FCONTACTSFLEX,FNUMBER1)
select FACCTID,FNUMBER,FPARENTID,FHELPERCODE,FGROUPID,FDC,FACCTTBLID,FISCASH,FISBANK,FISALLOCATE,FISCASHFLOW,FITEMDETAILID,FISQUANTITIES,FUNITGROUPID,FUNITID,FISDETAIL,FLEVEL,FCREATEORGID,FCREATORID,FCREATEDATE,FUSEORGID,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDSTATUS,FFORBIDDERID,FFORBIDDATE,FMASTERID,FISSYSPRESET,FDOCUMENTSTATUS,FCFItemID,FCFINDIRECTITEMID,FOCFITEMID,FOCFINDIRECTITEMID,FALLCURRENCY,FCURRENCYLIST,FCURRENCYS,FCONTROLORGID,FISSHOWJOURNAL,FAMO