fn_rnd (Transact_SQL)

See also:


This scalar UDF a random number between 0 and 1. Similar with TSQL RAND() function it can be used in UDF.
 

Syntax

 fn_rnd(@seed) 

 

Arguments

@seed = INT, Optional seed, if used the function returns the same result for the same seed, use NULL for random seed;

 

Return type

FLOAT

Remarks

none

 

Permissions

Public

 

Dependencies

none

 

Examples

SELECT*FROM [Lib].[tsql].[fn_rnd](NULL)

 

Other

none

Last edited Aug 27, 2012 at 7:02 PM by adudau, version 4

Comments

No comments yet.