e
q
u
e
s
t
a
d
e
m
o < back
CLR Reference: Decimal Number
{TOC}
"Decimal Number"
CLR function
<.CLRSQLCLR: function:
SELECT xxxxx(xxx,xxx,xxx)>[dbo].[NumberRandom] (<@number, numeric(18)>, <@range, int>)
Expected input
<.expectedData: input:NUMERIC data(18) type,value rule,(decimal sample>in .NET)
Range: acceptable range to shift value
Expected output
<.expectedNUMERIC output:(18) data type, rule, sample>value.
Error###Error handling
<.error handling>
Example
<.example>SQL CLR:
SELECT [dbo].[NumberRandom] (123, 100)