Insert 2000 data records cyclically in SQL Server 1 million (original)

Some time ago, when testing more than 1 million data records, we needed to insert 1 million records into the database. At that time, I used C # To insert records. Later, we found that, in fact, you can also use SQL to implement it, and it is simpler! The following is an example I wrote. It is very simple and you should be able to understand it.

Declare @ I int -- variable @ I
Set @ I = 1 -- initialize @ I to 1
While @ I <100 -- If @ I is less than 100, change to 1 million here to insert 1 million records
Begin ------------------
Insert into Manager (username, userpwd) values ('kgdids', '123 ')
Set @ I = @ I + 1
End --------------------

it's easy. In fact, SQL is also very powerful, and many things can be done by themselves. in the past, I put a lot of things in the Program . Now I am used to the SQL, because it can be easily modified.