22,207
社区成员
发帖
与我相关
我的任务
分享
create table t(id int identity,c varchar(100));
go
insert into t select NEWID()
go 1000
select * from t;
select
SQL:
--> 生成测试数据表: [tb]
IF OBJECT_ID('[tb]') IS NOT NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb] (id [int] identity,[col] [nvarchar](10))
GO
insert tb
select 1
go 100000
select * from tb
DECLARE v1 INT DEFAULT 5;
WHILE v1 <= 100000 DO
insert into tb(id,value) values(v1,'item'+ltrim(v1));
SET v1 = v1 + 1;
END WHILE;
declare @i int
set @i=1
while @i<=100000
begin
insert into tb(id,value) values(@i,'item'+ltrim(@i))
set @i=@i+1
end
select * from tb
while i<=100000
insert into tableName ...