UFN_COUNTRY_GETCOUNTRYCODES

Returns all country IDs and their corresponding country code.

Return

Return Type
table

Definition

Copy



CREATE function dbo.UFN_COUNTRY_GETCOUNTRYCODES()
returns Table
as return

    select
        ID as COUNTRYID,
        COUNTRYCODE
    from dbo.COUNTRY
    where COUNTRYCODE <> ''