CLR Reference: Country Code

{TOC}

"Country Code"

CLR function

SQLCLR:

SELECT [dbo].[CountryRandom] (<@country, nvarchar(4000)>)

Expected input

Data: Valid Country name or Code (based on ISO 3166)

Expected output

Valid Country Name or Code (based on ISO 3166) string (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value.

Example

SQLCLR:

SELECT [dbo].[CompanyNameRandom] ('US')