sql 事务语句
create procedure [dbo].[Proc_Prepaid]
as
begin
BEGIN TRY
BEGIN TRAN;
declare @Stat int;
set @Stat=0;
--定义变量
.........
select @Stat;
COMMIT TRAN;
END TRY
BEGIN CATCH
ROLLBACK TRAN;
END CATCH
end