UFN_ZIPCITYSTATE_GETCOUNTRIES

This function returns all distinct countries in the ZIPCITYSTATE table.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES()
            returns table
            as 
            return
                select distinct
                    COUNTRY.ID as COUNTRYID,
                    COUNTRY.DESCRIPTION as COUNTRYNAME
                from 
                    dbo.ZIPCITYSTATE ZCS
                inner join
                    dbo.COUNTRY on ZCS.COUNTRYID = COUNTRY.ID