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 Comment