USP_CREDITCARD_CREDITCARDTOKENGET

Returns credit card token.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@CREDITCARDTOKEN uniqueidentifier INOUT
@CREDITCARDPARTIALNUMBER nvarchar(4) INOUT

Definition

Copy


CREATE procedure dbo.USP_CREDITCARD_CREDITCARDTOKENGET
(
    @ID uniqueidentifier,
    @CREDITCARDTOKEN uniqueidentifier = null output,
  @CREDITCARDPARTIALNUMBER nvarchar(4) = null output
)
as
begin

  select @CREDITCARDTOKEN = CREDITCARDTOKEN,
    @CREDITCARDPARTIALNUMBER = CREDITCARDPARTIALNUMBER
  from dbo.[CREDITCARD](nolock)
  where ID = @ID;

  return 0
end