e
q
u
e
s
t
a
d
e
m
o
CLR Reference: URL
{TOC}
"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')