数据库插入测试数据

declare @var int
set @var=0
while(@var<10000000)
begin
INSERT INTO [dbo].[AppBooks]
           ([Id]
           ,[Name]
           ,[Type]
           ,[PublishDate]
           ,[Price]
           ,[ExtraProperties]
           ,[ConcurrencyStamp]
           ,[CreationTime]
           ,[CreatorId]
           ,[LastModificationTime]
           ,[LastModifierId]
           ,[AuthorId])
     VALUES
           (NEWID()
           ,@var
           ,0
           ,GETDATE()
           ,33
           ,'{}'
           ,NEWID()
           ,GETDATE()
           ,'06DEEF79-B042-7EC1-18CA-39FFF19F8388'
           ,null
           ,null
           ,'D7CE270B-6C71-A0DA-F00A-39FFF1A1F028')
    set @var=@var+1
end