One way is to INSERT into your table from a SELECT statement. You can use any table or function that returns a bunch of numbers - tally table, numbers table, numbers function.
For instance this is a table in the master database of sql server:
--insert myTable (phoneNumber)
select number + 10000 as phoneNumber
from master..spt_values
where type = 'p'
and number < 100
Be One with the Optimizer
TG
Multiple Insert
Posted - 06/25/2012 : 16:49:57
