SQL Server MRAND Function

Updated 2023-10-20 15:01:52.987000

Description

Use the scalar function MRAND to generate an m-by-n matrix of pseudo-random numbers greater than or equal to zero and less than one.

Syntax

SELECT [westclintech].[wct].[MRAND](
  <@m, int,>
 ,<@n, int,>)

Arguments

@m

The number of rows in the random number matrix.

@n

The number of columns in the random number matrix.

Return Type

nvarchar(max)

Remarks

@m must be greater than or equal to 1.

@n must be greater than or equal to 1.

Examples

The following statement will produce the 5-by-5 matrix of random numbers.

SELECT wct.MRAND(5, 5) as MRAND;

This produces the following result.

Since this is a matrix of random numbers, your results will be different.

We can use the table-valued function MATRIX to produce the output in third-normal form.

SELECT *
FROM wct.MATRIX(wct.MRAND(5, 5));

This produces the following result.