CLR Reference: URL

{TOC}

"URL"

CLR function

<.CLRSQLCLR: function:

SELECT xxxxx(xxx,xxx,xxx)>[dbo].[UrlRandom] (<@url, nvarchar(4000)>, <@type INT>)

Expected input

<.expectedData: input:Valid dataURL type,value Type: rule,numeric sample>flag for type (default is 0). Possible values: 0 – All 1 – Healthcare 2 – Finance 3 – Education 4 – Ecommerce

Expected output

<.expectedGeneric output:URL dataof type,corresponding rule,input sample>type (nvarchar(MAX))

Error handling

<.errorReturns handling>an empty string when passing empty, NULL value. Return value itself on incorrect url format.

Example

<.example>SQLCLR:

SELECT [dbo].[UrlRandom] ('https://msdn.microsoft.com')