-- 使用 CTE 生成随机数据
WITH RandomDataCTE AS (
    SELECT TOP 1000000
      id =  ABS((CHECKSUM(NEWID())+cast((RAND()*(50-10)+10)*1000000 as bigint))%900000000000)+100000000000
    FROM master..spt_values t1
    CROSS JOIN master..spt_values t2
)

-- 查询随机数据
SELECT * FROM RandomDataCTE