CLR Reference: URL
-
Request
a trial -
Request
a demo -
Request
a quote
CLR Data Masking Components
Open Navigation Article
CLR Reference: URL
-
Request
a trial -
Request
a demo -
Request
a quote
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')
×
![Enlarged Picture]()
CLR Reference: URL
Download Manual
