---循ç¯æå
¥æ°æ®
CREATE TABLE #t (id int IDENTITY(1,1) PRIMARY KEY,nums int)
GOINSERT INTO #t
SELECT abs(CHECKSUM(NEWID())%100000) ----çæ10000ç¬èµæ,å¯ä»¥æ¯ä»»æä¸æ°å,æ°å代表循ç¯ç次æ°
GO 10000 --è¿éå个20ä¸å°±å¯ä»¥äºè¿ä¸ªåªéäºsql 2005 å08ä¸é¢ä»ç»ä¸ªéç¨çï¼ç¨å¾ªç¯IF OBJECT_ID('TB') IS NOT NULL
DROP TABLE TB
GO
CREATE TABLE TB(ID INT IDENTITY(1,1),IMG VARCHAR(50))
GO
DECLARE @i int
DECLARE @name varchar(50)
Set @i = 1
WHILE @i < 200000000BEGIN
insert into TB values.......................
Set @i =@i +1
END
GO
SELECT * FROM TB
温馨提示:答案为网友推荐,仅供参考