Click or drag to resize
sqx

SQXSafeDiv Method

Function [float] SafeDiv([float] Numerator, [float] Denominator)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static SqlDouble SafeDiv(
	SqlDouble Numerator,
	SqlDouble Denominator
)

Parameters

Numerator
Type: System.Data.SqlTypesSqlDouble
[float]
Denominator
Type: System.Data.SqlTypesSqlDouble
[float]

Return Value

Type: SqlDouble
[float]
Remarks
Safe division function.
Implicit conversion to [float].
Returns NULL on division by Zero.
Examples
SQL
Copy
SELECT Value, sqx.SafeDiv(5, Value) [5/Value]
FROM sqx.NTable(0,2)
/*
Value       [5/Value]
----------- ------
0           NULL
1           5
2           2.5*/
See Also