如何插入5000条以上的记录 [英] How to Insert 5000+ records

问题描述

如何使用SQL在1个表中插入500000条记录，并且emailId列不应重复，应始终为新的emailId.

在此先感谢，

Priya.

How to Insert 5000 thousand records in 1 table using SQL, and the column emailId should not repeat it should be always new emailId.

Thanks in Advance,

Priya.

推荐答案

尝试:

DECLARE @count INT
SET @count = 1
WHILE (@count <= 5000)
BEGIN
   INSERT INTO myTable(Email) VALUES ('priya'+ CONVERT(nvarchar, @count) + '@gmail.com')
   SET @count = (@count + 1)
END

DECLARE @UserId INT
SET @count = 1
WHILE (@count <= 5000)
BEGIN
   INSERT INTO tblUser1(EmailID, UserTypeID,FirstName,LastName,PhoneNumber,UniversityID,RegisterDate,ActivationDate,Status,Password,IsAV)
                VALUES ('priyanka'+ CONVERT(nvarchar, @count) + '@gmail.com',5,'priya','darshini','5468927689',10,'2012-04-12 02:09:59.040',null,1,'Test123',1)
   SET @count = (@count + 1)
   SELECT @UserId = @@IDENTITY

   INSERT INTO tblAddress1(UserID,AddressLine1,AddressLine2,City,StateID,ZipCode) Values(@UserId,'test',NULL,'Hyd',34,50040)

END

这篇关于如何插入5000条以上的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！