Not logged in - Login / Register


View History
R
e
q
u
e
s
t

a

d
e
m
o

CLR Reference: 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)

Download a Trial