decimal_division()

Divides two DECIMAL values using exact integer arithmetic and round-half-to-even, returning a DECIMAL result with scale determined by SQL Server semantics (result_scale = max(6, s1 + p2 + 1)).

Reference: Haybarn WASM 2.0.0-rc12

Arguments & returns

2 overloads

decimal_division(x, y)

Scalar
Overload link xy Returns
#01 DECIMALDECIMAL DECIMAL

decimal_division(x, y, scale)

Scalar
Overload link xyscale Returns
#02 DECIMALDECIMALINTEGER DECIMAL

Example

decimal_division example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.