in

SQL Server Community Blogs

Voices of the SQL Server Community

Browse by Tags

  • 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 ( newid () as varbinary ( 10 )) as int )) as number...
    Posted to Madhivanan (Weblog) by Madhivanan on 10-10-2007
  • 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 Declare @t table(num bigint) Declare @start bigint...
    Posted to Madhivanan (Weblog) by Madhivanan on 08-27-2007
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems