UFN_BBNC_EDUCATIONALINSTITUTION_GETID

Returns the EDUCATIONAL INSTITUTION ID for the specified name for Blackbaud Internet Solutions.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_EDUCATIONALINSTITUTION_GETID(@NAME nvarchar(100)) 
            returns uniqueidentifier
            as begin
                return (
                    select ID
                    from dbo.EDUCATIONALINSTITUTION
                    where NAME = @NAME
                    )
            end