产生10000条连续记录

核心提示：产生 10000 条连续记录PRINT CONVERT(VARCHAR(50), GETDATE(), 21)select id = a.id + b.id + c.id + d.id + 1from( select id = 0 union all select 1 union all select 2 uni

产生 10000 条连续记录

PRINT CONVERT(VARCHAR(50), GETDATE(), 21)select id = a.id + b.id + c.id + d.id + 1from( select id = 0  union all select 1  union all select 2  union all select 3  union all select 4  union all select 5  union all select 6  union all select 7  union all select 8  union all select 9  ) a,( select id = 0  union all select 10 union all select 20  union all select 30 union all select 40  union all select 50 union all select 60  union all select 70 union all select 80  union all select 90 ) b,( select id = 0  union all select 100 union all select 200  union all select 300 union all select 400  union all select 500 union all select 600  union all select 700 union all select 800  union all select 900 ) c,( select id = 0  union all select 1000 union all select 2000  union all select 3000 union all select 4000  union all select 5000 union all select 6000  union all select 7000 union all select 8000  union all select 9000 ) dorder by idPRINT CONVERT(VARCHAR(50), GETDATE(), 21)