SQL Server MRANDN Function

Updated 2023-10-20 15:03:47.133000

Description

Use the scalar function MRANDN to generate an m-by-n matrix of pseudo-random numbers from the standard normal distribution.

Syntax

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

Arguments

@m

The number of rows in the matrix.

@n

The number of columns in the 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 pseudo-random numbers from the standard normal distribution.

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

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.MRANDN(5,5));

This produces the following result.