CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
SSN Dynamic
CLR function
SQLCLR:
SELECT [dbo].[SSNDynamic] (<@ssn, nvarchar(4000)>)
Expected input
Data: 9 digits string (can contain extra characters separators)
Expected output
Generic USA SSN (nvarchar(MAX))
Error handling
Returns an empty string when passing empty or NULL value. Fails on invalid SSN format
Example
SQLCLR:
SELECT [dbo].[SSNDynamic] ('123456789')
×
CLR Reference: SSN Dynamic
CLR Reference: SSN Dynamic
- 1. SSN Dynamic
- 1.1 CLR function
- 1.2 Expected input
- 1.3 Expected output
- 1.4 Error handling
- 1.5 Example
CLR Data Masking Components
CLR Reference