UFN_NAMEFORMATFUNCTIONISVALID
Validates a name format function.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FORMATSQLFUNCTION | nvarchar(200) | IN |
Definition
Copy
create function dbo.UFN_NAMEFORMATFUNCTIONISVALID(@FORMATSQLFUNCTION nvarchar(200))
returns bit
with execute as caller
as begin
declare @NUMVALIDFIELDS int
--NameFormatParamList
select @NUMVALIDFIELDS = count(*) from INFORMATION_SCHEMA.PARAMETERS where SPECIFIC_NAME = @FORMATSQLFUNCTION and (
(ORDINAL_POSITION = 1 and PARAMETER_NAME = '@CONSTITUENTID' and DATA_TYPE = 'uniqueidentifier') or
(ORDINAL_POSITION = 2 and PARAMETER_NAME = '@LASTNAME' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 3 and PARAMETER_NAME = '@FIRSTNAME' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 4 and PARAMETER_NAME = '@MIDDLENAME' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 5 and PARAMETER_NAME = '@TITLE' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 6 and PARAMETER_NAME = '@SUFFIX' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 7 and PARAMETER_NAME = '@SPOUSELASTNAME' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 8 and PARAMETER_NAME = '@SPOUSEFIRSTNAME' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 9 and PARAMETER_NAME = '@SPOUSEMIDDLENAME' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 10 and PARAMETER_NAME = '@SPOUSETITLE' and DATA_TYPE = 'nvarchar') or
(ORDINAL_POSITION = 11 and PARAMETER_NAME = '@SPOUSESUFFIX' and DATA_TYPE = 'nvarchar'))
if @NUMVALIDFIELDS = 11
return 1
return 0
end