spTransactions_FailEventTransaction
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @Status | int | IN | |
| @FailureData | varchar(max) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spTransactions_FailEventTransaction]
( @PKID int, @Status int, @FailureData varchar(max)) AS
UPDATE [dbo].[EventTransactions] SET [FailureData] = @FailureData, [Status] = @Status WHERE [EventTransactionsID] = @PKID
DELETE FROM [dbo].[Transactions] WHERE TransactionID=@PKID AND TransactionType='{172A5D9A-5241-493c-A2C2-EAC164C095B0}'