执行存储过程回滚事务

set XACT_ABORT on

begin tran
DECLARE @return_value int

EXEC @return_value = [dbo].[dd_orderproc_finalizelogisorder]
  @ordernum = N'T120813135462'

SELECT 'Return Value' = @return_value
commit
GO