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

The article was published on August 31, 2014 @ 10:54 AM

Leave a Comment