循环插入10000条记录

Question

DECLARE @I INT
SET @I = 1
INSERT INTO [tstring_test].[dbo].[UserInfo]
           ([UserName]
           ,[UserPass]
           ,[UserEmail])
     VALUES(
           'kkun',
           '624159',
           '[email protected]')WHILE(@I < 10000)
BEGIN
INSERT INTO [tstring_test].[dbo].[UserInfo] (UserName,UserPass,UserEmail)
SELECT UserName,UserPass,UserEmail FROM [UserInfo]
SET @I = @I * 2
END
SELECT COUNT(0) FROM [UserInfo]