CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
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')
×
CLR Reference: Country Code
CLR Reference: Country Code
- 1. Country Code
- 1.1 CLR function
- 1.2 Expected input
- 1.3 Expected output
- 1.4 Error handling
- 1.5 Example
CLR Data Masking Components
CLR Reference