UFN_QTRANSLATE_COUNTRY_GETLONGDESCRIPTION

This function returns the description for a given country.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_QTRANSLATE_COUNTRY_GETLONGDESCRIPTION(@ID uniqueidentifier) returns nvarchar(100)
            AS
            --Used by QueryViews and SmartQueries

            BEGIN
                declare @DESCRIPTION nvarchar(100)

                select @DESCRIPTION = DESCRIPTION from dbo.COUNTRY where ID = @ID

                RETURN @DESCRIPTION
            END