UFN_COUNTRY_GETID

Returns the ID of a country given it's description.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@DESCRIPTION	nvarchar(100)	IN
@USEABBREVIATION	bit	IN

Definition

Copy



            create function dbo.UFN_COUNTRY_GETID(@DESCRIPTION nvarchar(100), @USEABBREVIATION bit)
            returns uniqueidentifier 
            with execute as caller
            as begin
                declare @r uniqueidentifier
                if @USEABBREVIATION=0
                    select @r=ID from dbo.COUNTRY where DESCRIPTION = @DESCRIPTION
                else
                    select @r=ID from dbo.COUNTRY where ABBREVIATION = @DESCRIPTION
                return @r
            end