Õª×Ôhttp://hi.baidu.com/dusongw/blog/item/4090493d6ec0cdee3d6d97a6.html
ÎÒ½«ÒÔ“°ì¹«×Ô¶¯»¯”ϵͳΪÀý£¬Ì½ÌÖÈçºÎÔÚÓÐ×Å1000ÍòÌõÊý¾ÝµÄMS SQL SERVERÊý¾Ý¿âÖÐʵÏÖ¿ìËÙµÄÊý¾ÝÌáÈ¡ºÍÊý¾Ý·ÖÒ³¡£ÒÔÏ´úÂë˵Ã÷ÁËÎÒÃÇʵÀýÖÐÊý¾Ý¿âµÄ“ºìÍ·Îļþ”Ò»±íµÄ²¿·ÖÊý¾Ý½á¹¹£º
CREATE TABLE [dbo].[TGongwen] ( --TGongwenÊǺìÍ·Îļþ±íÃû
[Gid] [int] IDENTITY (1, 1) NOT NULL ,
--±¾±íµÄidºÅ£¬Ò²ÊÇÖ÷¼ü
[title] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
--ºìÍ·ÎļþµÄ±êÌâ
[fariqi] [datetime] NULL ,
--·¢²¼ÈÕÆÚ
[neibuYonghu] [varchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
--·¢²¼Óû§
[reader] [varchar] (900) COLLATE Chinese_PRC_CI_AS NULL ,
--ÐèÒªä¯ÀÀµÄÓû§¡£Ã¿¸öÓû§ÖмäÓ÷ָô·û“,”·Ö¿ª
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ÏÂÃ棬ÎÒÃÇÀ´ÍùÊý¾Ý¿âÖÐÌí¼Ó1000ÍòÌõÊý¾Ý£º
declare @i int
set @i=1
while @i<=250000
begin
insert into Tgongwen(fariqi,neibuyonghu,reader,title) values('2004-2-5','ͨÐÅ¿Æ','ͨÐÅ¿Æ,°ì¹«ÊÒ,Íõ¾Ö³¤,Áõ¾Ö³¤,Õžֳ¤,admin,ÐÌÕìÖ§¶Ó,ÌØÇÚÖ§¶Ó,½»Ñ²¾¯Ö§¶Ó,¾ÕìÖ§¶Ó, »§Õþ¿Æ,Öΰ²Ö§¶Ó,ÍâÊ¿Æ','ÕâÊÇ×îÏȵÄ25ÍòÌõ¼Ç¼')
set @i=@i+1
end
GO
declare @i int
set @i=1
while @i<=250000
begin
insert into Tgongwen(fariqi,neibuyonghu,reader,title) values('2004-9-16','°ì¹«ÊÒ','°ì¹«ÊÒ,ͨÐÅ¿Æ,Íõ¾Ö³¤,Áõ¾Ö³¤,Õžֳ¤,admin,ÐÌÕìÖ§¶Ó,ÌØÇÚÖ§¶Ó,½»Ñ²¾¯Ö§¶Ó,¾ÕìÖ§¶Ó,»§Õþ¿Æ,ÍâÊ¿Æ','ÕâÊÇÖмäµÄ25ÍòÌõ¼Ç¼')
set @i=@i+1
end
GO
declare @h int
set @h=1
while @h<=100
begin
declare @i int
set @i=2002
while @i<=2003
begin