Technical Article

Generate N numbers

,

Following script is a quick and easy way to generate 10000 numbers . You can change the number to generate howmany ever numbers you want.

WITH Number
     AS (SELECT 1 AS n
         UNION ALL
         SELECT n + 1
         FROM   Number
         WHERE  n < 10000)
SELECT n
FROM   Number
OPTION ( MAXRECURSION 10000 );

Rate

3.38 (8)

You rated this post out of 5. Change rating

Share

Share

Rate

3.38 (8)

You rated this post out of 5. Change rating