fnGetSiteCodeTableEntryDescription

Return

Return Type
nvarchar(256)

Parameters

Parameter Parameter Type Mode Description
@CodeTableID int IN
@EntryGUID uniqueidentifier IN

Definition

Copy


        CREATE function [dbo].[fnGetSiteCodeTableEntryDescription]
        (    
            @CodeTableID int
            @EntryGUID uniqueidentifier
        )
        returns nvarchar(256)
        as
        begin
            /* @CodeTableID Values
            Public Enum ESiteCodeTableTypes as Integer
                EventCalendarCategories = 1
            End Enum
            */
            return (Select Description from dbo.SiteCodeTableEntries
                    Where CodeTablesID = @CodeTableID 
                    And EntryGUID = @EntryGUID)            
        end