declare @errcode int
set @errcode=1900
--启动事务
declare @tran_point int
set @tran_point=@@trancount
if @tran_point=0
begin tran tran_yckp_pd
else
save tran tran_yckp_pd
數據庫腳本運行
IF @@ERROR<>0
BEGIN
SET @return=24
GOTO err_lab
END
if @tran_point=0
commit tran tran_yckp_pd
goto return_lab
err_lab:
if @return<100 set @return=@errcode +@return
rollback tran tran_yckp_pd
return_lab:
return @return