Not logged in - Login / Register


View History
R
e
q
u
e
s
t

a

d
e
m
o

CLR Reference: URL

"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')

Download a Trial