CLR Reference: Names With Gender

{TOC}

"Name With Gender"

CLR function

<.CLRSQLCLR: SELECT function:[dbo].[NameWithGenderDynamic] xxxxx(xxx,xxx,xxx)>(<@name, nvarchar(4000)>, <@gender NVARCHAR (4000)>) SELECT [dbo].[NameWithGenderRandom] (<@name, nvarchar(4000)>, <@gender NVARCHAR (4000)>)

Expected input

<.expectedData: input:Any datanon-empty type,string gender: rule,Gender sample>Clause (ex. Ms., Mrs, etc.). Can be empty.

Expected output

<.expectedGender output:is datanon-empty type,and rule,has sample>valid gender format or name contains gender clause: Common Name with corresponding gender (nvarchar(MAX)) Gender is empty or has invalid format and name doesn’t contain gender clause: Common unisex name

Error handling

<.errorReturns handling>an empty string when passing empty or NULL value in name parameter.

Example

<.example>SQLCLR:

SELECT [dbo].[NameWithGenderRandom] ('Kate Portman', 'Ms')