[p]Yes. I put everything in MS_Description because this is the only thing that is accessible to SSMS. I then put a YAML structure into the string so I can do lists and sections.[/p]
[p]The section between the /** **/ is placed into, or updated to, the extended property by an automated process. [/p]
[font="Courier New"]
IF OBJECT_ID(N'IsSpace') IS NOT NULL
DROP FUNCTION IsSpace
GO
CREATE FUNCTION dbo.[IsSpace] (@string VARCHAR(MAX))
/**
summary: >
IsSpace string Function Returns Non-Zero if all characters
in s are whitespace characters, 0 otherwise.
example:
- code: Select dbo.IsSpace('how many times must i tell you')
- code: Select dbo.IsSpace(' <>[]{}"!@#$%9 )))))))')
- code: Select dbo.IsSpace(' ????/>.<,')*/
returns: integer: 1 IF whitespace, otherwise 0
**/
RETURNS INT
AS BEGIN
RETURN CASE WHEN PATINDEX(
'%[A-Za-z0-9-]%', @string COLLATE Latin1_General_CS_AI
) > 0 THEN 0
ELSE 1
END
END
GO
[/font]
Best wishes,
Phil Factor