In this article, we want to discuss about a nice function to random number generator script in SQL Server. Before we get started, if you want to know about split with any delimited string, please go through the following article: Update table from another table in SQL Server.

There are many methods to generate random number in SQL Server. Let’s start.

Method 1 : Generate Random Numbers (Int) between Rang

 

Method 2 : Generate Random Float Numbers

 

Method 3 : Random Numbers Quick Scripts

 

Method 4 : Random Numbers (Float, Int) Tables Based with Time

 

Method 5 : Random number on a per row basis
Random Number Generator Script – SQL Query

Leave a Reply