让SQL Server 自动添加100万条测试记录!

USE [data]GO/****** 对象:  Table [dbo].[news]    脚本日期: 03/13/2015 10:33:49 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[news]( [id] [int] IDENTITY(1,1) NOT NULL, [title] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL, [body] [text] COLLATE Chinese_PRC_CI_AS NULL, [addtime] [datetime] NULL, CONSTRAINT [PK_news] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

 

/****** 对象:  Table [dbo].[news]    脚本日期: 03/13/2015 10:33:49 ******/declare @i intset @i=1while @i<=1000000begininsert into news(title,body) values('我的分页算法','原点互联域名49/年啦')set @i=@i+1endGO