Logo

SQL Server QUOTIENT Function

Updated 2023-10-13 20:51:29.703000

Description

Use the scalar function QUOTIENT returns the integer portion of a division.

Syntax

SELECT [westclintech].[wct].[QUOTIENT] (
  <@Numerator, float,>
 ,<@Denominator, float,>)

Arguments

@Numerator

is the dividend. @Numerator is an expression of type float or of a type that can be implicitly converted to float.

@Denominator

is the divisor. @Denominator is an expression of type float or of a type that can be implicitly converted to float.

Return Type

float

Examples

SELECT wct.QUOTIENT(-5, 2);

Here is the result set.

column 1
-2