SQL Eval Function Math_IEEERemainder

Math_IEEERemainder returns the remainder resulting from the division of a specified number by another specified number.

Math_IEEERemainder (
	@x INT,
	@y INT)
RETURNS BIGINT

Parameters

  • x: A dividend.
  • y: A divisor

Returns

A number equal to x - (y Q), where Q is the quotient of x / y rounded to the nearest integer (if x / y falls halfway between two integers, the even integer is returned).

Example

SELECT SQLNET::Math_IEEERemainder(3, 2)
SELECT SQLNET::Math_IEEERemainder(-16.3, 4.1)

Contents