CLR Reference: Decimal Number

**{TOC}

"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)