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 26, 2012 at 9:14 am

    #1464335

    Krtyknm (3/26/2012)

    Hi Jeff,

    Nice Article, Keep going.

    I have a question on sys tables, most of them using the Sys.tables for generating random numbers. Assume that developers don't have an access to System tables, then how can they get the random numbers.

    Thanks,

    Karthik

    In addition to what has already been said about using other tables, or creating a tally table, it is also possible to create a dynamic tally table using CTEs in SQL Server 2005 and newer. You can find numerous examples of these in the forums and articles on SSC.