UFN_OUTPUTTABLE_HASREQUIREDEMAILCOLUMNS

Returns true if the given output table has the given columns.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@TABLENAME	nvarchar(58)	IN
@EMAILADDRESSCOLUMN	nvarchar(255)	IN
@FULLNAMECOLUMN	nvarchar(255)	IN

Definition

Copy



CREATE function dbo.UFN_OUTPUTTABLE_HASREQUIREDEMAILCOLUMNS
(
    @TABLENAME as nvarchar(58),
    @EMAILADDRESSCOLUMN as nvarchar(255),
    @FULLNAMECOLUMN as nvarchar(255)
)
returns bit
with execute as caller
as begin

    declare @count as tinyint;

    select 
        @count = COUNT(COLUMN_NAME)
    from 
        INFORMATION_SCHEMA.COLUMNS 
    where 
        TABLE_NAME = @TABLENAME
        and
        (
            COLUMN_NAME = @EMAILADDRESSCOLUMN
            or
            COLUMN_NAME = @FULLNAMECOLUMN
        )

    declare @returnValue as bit = 0;
    if @count = 2
        set @returnValue = 1;

    return @returnValue;
end