Not logged in - Login / Register


View History

CLR Reference: URL Dynamic

"URL Dynamic"

CLR function

SQLCLR:

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