In this article, we want to discuss 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 numbers 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 on Time


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

Leave a Comment