sql 循环插入20万条数据

最新推荐文章于 2024-05-23 20:46:50 发布

原创最新推荐文章于 2024-05-23 20:46:50 发布 · 1.4k 阅读

CC 4.0 BY-SA版权

DECLARE @number INT
SET @number = 200000

WHILE @number > 0
BEGIN
     INSERT dbo.Article
       (
         MsId,
         Title,
        TitleBak,
        Summary,
        SummaryImageUrl,

        Tag,
        ArticleChannel_Id,
        ArticleCategory_Id,
        IsApproved,
        Creator_Id,

        CreatedDateTime,
        ModifiedDateTime,
        ViewCount,
        ReplyCount,
        DiggCount,
        FavoriteCount,
        LastReplyUser_Id,
        LastReplyDateTime,
        RightType,
        IsDisplayContent,
        IsSensitive,
        Source
      )
    VALUES
      (
          @number,
        'Title'+cast(@number AS VARCHAR(20)),
        'TitleBak'+cast(@number AS VARCHAR(20)),
        'Summary'+cast(@number AS VARCHAR(20)),
        'SummaryImageUrl'+cast(@number AS VARCHAR(20)),
        'Tag'+cast(@number AS VARCHAR(20)),
        1,
        2,
        0,
        @number,
       GETDATE(),
       GETDATE(),
        100,
        29,
        123,
       12,
        @number,
        GETDATE(),
        1,
        0,
        0,
        2

      )
      SET @number=@number-1
END