Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Generating Test Data: Part 1 - Generating Random Integers and Floats RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

  • March 27, 2012 at 3:51 am

    #1464823

    Hi Guys

    By declaring the variables as below - Will that guarantee that every number generated is Unique?

    SELECT @NumberOfRows = 10000000,

    @StartValue = 1,

    @EndValue = 10000000,

    @Range = @EndValue - @StartValue + 1

    Thanks