- Home
- Developer Center
- Documentation CLR Data Masking Components
- Decimal Number
CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
- Home
- Developer Center
- Documentation CLR Data Masking Components
- Decimal Number
Decimal Number
CLR function
SQLCLR:
SELECT [dbo].[NumberRandom] (<@number, numeric(18)>, <@range, int>)
Expected input
Data: NUMERIC (18) value (decimal in .NET)
Range: acceptable range to shift value
Expected output
NUMERIC (18) value.
Error handling
-
Example
SQL CLR:
SELECT [dbo].[NumberRandom] (123, 100)
×
CLR Reference: Decimal Number
CLR Reference: Decimal Number
- 1. Decimal Number
- 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