e
q
u
e
s
t
a
d
e
m
o < back
CLR Reference: Address Dynamic
{TOC}
"Address Dynamic"
CLR function
<.CLRSQLCLR:
SELECT function:[dbo].[AddressDynamic] xxxxx(xxx,xxx,xxx)>(<@address, nvarchar(4000)>)
Expected input
<.expectedAn input:address: dataAddress type,Line rule,1 sample>or/and 2. (Any address form)
Expected output
<.expectedAn output:address: dataAddress type,Line rule,1 sample>or/and 2. ([Street number] [Street direction] [Street name] [Street type])
Error handling
<.errorReturns handling>an empty string when passing empty or NULL value.
Example
<.example>SQLCLR:
SELECT [dbo].[AddressDynamic] ('12 Ocean St')