Not logged in - Login / Register


R
e
q
u
e
s
t

a

d
e
m
o
< back

CLR Reference: URL Dynamic

"URL Dynamic"

CLR function

<.CLRSQLCLR: function:

SELECT xxxxx(xxx,xxx,xxx)>[dbo].[UrlDynamic] (<@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].[UrlDynamic] ('http://edu.us')

Download a Trial