RANDOM_INT (TSQL Function)

Returns a random int between the two values passed as arguments, inclusively.

Syntax

RANDOM_INT ( startval , endval )

Arguments

startval
is the start value, of type int. It must be a constant literal.
endval
is the end value, of type int. It must be a constant literal.

Return Types

Returns int.

Remarks

The returned value is uniformly distributed.

This function doesn’t exist in MS SQL Server.

You should use it to easily fill your test tables with random int values.

Examples

See RANDOM_VARCHAR and RANDOM_NUMERIC.