CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
URL
CLR function
SQLCLR:
SELECT [dbo].[UrlRandom] (<@url, nvarchar(4000)>, <@type INT>)
Expected input
Data: Valid URL value Type: numeric flag for type (default is 0). Possible values: 0 – All 1 – Healthcare 2 – Finance 3 – Education 4 – Ecommerce
Expected output
Generic URL of corresponding input type (nvarchar(MAX))
Error handling
Returns an empty string when passing empty, NULL value. Return value itself on incorrect url format.
Example
SQLCLR:
SELECT [dbo].[UrlRandom] ('https://msdn.microsoft.com')
×
CLR Reference: URL
CLR Data Masking Components
CLR Reference