--生成数据库
CREATE TABLE Test1
(
col1 int,
col2 char(10) NULL,
)
GO
--循环插入(插入一百万条数据)
DECLARE @num int
SET @num = 1
WHILE @num <= 1000000
BEGIN
INSERT INTO Test1 VALUES(@num, 'A' + CONVERT(char(10), @num))
SET @num = @num + 1
END
--生成数据库
CREATE TABLE Test1
(
col1 int,
col2 char(10) NULL,
)
GO
--循环插入(插入一百万条数据)
DECLARE @num int
SET @num = 1
WHILE @num <= 1000000
BEGIN
INSERT INTO Test1 VALUES(@num, 'A' + CONVERT(char(10), @num))
SET @num = @num + 1
END