Browse by Tags

All Tags » random numbers (RSS)
10 October 2007 09:10

Generating Random Numbers - Part II

There are many methods to generate random numbers. Here are some of them select number from ( select top 10000 abs ( checksum ( newid ())) as number from sysobjects s1 cross join sysobjects s2 ) as T select number from ( select top 1000 abs ( cast ( cast...
Posted by Madhivanan | with no comments
Filed under: , ,
27 August 2007 16:23

Generate Random Numbers

This procedure will display n random numbers selected from specified range Pass Starting Number, Ending Number and the number of numbers you want to select randomly Create Procedure RandomNumbers (@min bigint, @max bigint, @count int) as Set Nocount On...
Posted by Madhivanan | with no comments
Filed under: , ,