Pages

Saturday, September 21, 2013

SQL SERVER – Random Number Generator Script – SQL Query | Journey to SQL Authority with Pinal Dave

Random Number Generator There are many methods to generate random number in SQL Server. Method 1 : Generate Random Numbers (Int) between Rang ---- Create the variables for the random number generation DECLARE @Random INT; DECLARE @Upper INT; DECLARE @Lower INT ---- This will create a random number between 1 and 999 SET @Lower =… Continue Reading...

Source: SQL SERVER – Random Number Generator Script – SQL Query | Journey to SQL Authority with Pinal Dave