spTransactions_FailMembershipTransaction
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @Status | int | IN | |
| @FailureData | varchar(max) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spTransactions_FailMembershipTransaction]
( @PKID int, @Status int, @FailureData varchar(max)) AS
UPDATE [dbo].[MembershipTransactions] SET [FailureData] = @FailureData, [Status] = @Status WHERE [ID] = @PKID
DELETE FROM [dbo].[Transactions] WHERE TransactionID=@PKID AND TransactionType='{D7D6143F-823D-4c74-AC2F-947CC96B7008}'