UFN_CREDITCARD_DOESTOKENEXIST

Checks if the token already exists in the database.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@CREDITCARDTOKEN uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_CREDITCARD_DOESTOKENEXIST
            (
                @CREDITCARDTOKEN uniqueidentifier
            )
            returns bit
            as
            begin
                if exists (select 1 from dbo.CREDITCARD where CREDITCARDTOKEN = @CREDITCARDTOKEN)
                    return 1

                return 0
            end