USP_FAIL_CMSTRANSACTIONS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STATUS | int | IN | |
| @STATUSTEXT | varchar(20) | IN | |
| @FAILDATA | nvarchar(1000) | IN | |
| @ID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_FAIL_CMSTRANSACTIONS
(
@STATUS integer,
@STATUSTEXT varchar(20),
@FAILDATA nvarchar(1000),
@ID uniqueidentifier
)
as
begin
update [dbo].[CMSTRANSACTIONS]
set
[STATUS] = @STATUS,
[STATUSTEXT] = @STATUSTEXT,
[FAILDATA] = @FAILDATA
where
[ID] = @ID;
return 0;
end