万级别数据,执行时间忽略不计,局限插入列要有规律
CREATE TABLE adminInfo
(
-- adminId -- this column value is auto-generated,
adminLoginName nvarchar(50),
adminPassword nvarchar(50),
adminLevel int
)
GO
CREATE PROCEDURE [dbo].[P_InsertAdminInfo]
@dataNumber INT -- 需要插入的数据量
AS
INSERT INTO adminInfo
SELECT TOP(@dataNumber)
'manager' + RTRIM(ROW_NUMBER() OVER(ORDER BY o.object_id)),
'1111111',
ABS(CHECKSUM(NEWID())) % 2 + 1
FROM sys.all_objects AS o,sys.all_columns AS c
GO
EXEC [dbo].[P_InsertAdminInfo] 500
SELECT * FROM adminInfo
GO
DROP TABLE adminInfo
DROP PROCEDURE [dbo].[P_InsertAdminInfo]