BEGIN TRY
BEGIN TRANSACTION
declare @iActionID int,@ErrorMessage varchar(MAX)
update xxxxxxx
IF @@TRANCOUNT > 0
COMMIT TRANSACTION ;
END TRY
BEGIN CATCH
SET @ErrorMessage=STR(ERROR_LINE())+'行:'+'信息:'+ERROR_MESSAGE()
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION ;
select @ErrorMessage as Error
END CATCH;
BEGIN TRANSACTION
declare @iActionID int,@ErrorMessage varchar(MAX)
update xxxxxxx
IF @@TRANCOUNT > 0
COMMIT TRANSACTION ;
END TRY
BEGIN CATCH
SET @ErrorMessage=STR(ERROR_LINE())+'行:'+'信息:'+ERROR_MESSAGE()
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION ;
select @ErrorMessage as Error
END CATCH;