程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SqlServer數據庫 >> 關於SqlServer >> 產生10000條連續記錄

產生10000條連續記錄

編輯:關於SqlServer
PRINT CONVERT(VARCHAR(50), GETDATE(), 21)

select id = a.id + b.id + c.id + d.id + 1

from(

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

) d

order by id

PRINT CONVERT(VARCHAR(50), GETDATE(), 21)
  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved