Collections:
RAND() - Generating Random Numbers in SQL Server
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL?
✍: FYIcenter.com
Random numbers are very useful for generating test data, passwords, or other security related data. SQL Server 2005 offers you the random number generator function RAND in two format:
Note that calling RAND(seed) with the same seed will start the same sequence and return the same number. To avoid this repeating pattern, you should always call RAND() without any seed and let the server to randomly pickup a sequence.
The tutorial exercise below shows some good examples on how to generate random numbers:
SELECT RAND(100), RAND(), RAND(); -- new sequence SELECT RAND(100), RAND(), RAND(); -- same sequence again SELECT RAND(), RAND(), RAND(); SELECT RAND(), RAND(), RAND(); GO 0.715436657367485 0.28463380767982 0.0131039082850364 0.715436657367485 0.28463380767982 0.0131039082850364 0.28769876521071 0.100505471175005 0.292787286982702 0.868829058415689 0.370366365964781 0.58334760467751 -- Random integer between 0 and 100 SELECT FLOOR(100*RAND()); SELECT FLOOR(100*RAND()); SELECT FLOOR(100*RAND()); SELECT FLOOR(100*RAND()); GO 68 29 20 82
⇒ Character Strings and Binary Strings in SQL Server Transact-SQL
⇐ ROUND() - Rounding Values to Specific Precisions in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-11, 5813🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...