e
q
u
e
s
t
a
d
e
m
o
CLR Reference: City Name
{TOC}
"City Name"
CLR function
SQLCLR:
SELECT [dbo].[CityNamesRandom] (<@alphaNumeric, nvarchar(4000)>)
Expected input
Data: Any non-empty string
Expected output
Valid City Name string (nvarchar(MAX))
Error handling
Returns an empty string when passing empty or NULL value.
Example
SQLCLR:
SELECT [dbo].[CityNamesRandom] ('New York')