SQLË÷ÒýÓÅ»¯µÄÎÊÌâ
Õª×Ô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 
Ïà¹ØÎĵµ£º
±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵à ......
//È¡³öÔ´Êý¾Ý
select groupname,totalnum,inputdate,groupid into #temp from
(select count(*)as totalnum,p.groupid,g.groupname,convert(nvarchar(10),inputdate,120) as 'inputdate'
from person p left join admin_group g on p.groupid = g.groupid and deleteflag = '0'
where p.inactive=' ......
http://blog.csdn.net/fenglibing/archive/2007/10/24/1841537.aspx
1¡¢½«Ò»¸ö±íÖеÄÄÚÈÝ¿½±´µ½ÁíÍâÒ»¸ö±íÖÐ
insert into testT1(a1,b1,c1) select a,b,c from test;
insert into testT select * from test; (Ç°ÌáÊÇ兩個±íµÄ結構ÍêÈ«Ïàͬ)
insert into notebook(id,title,content)
se ......
1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½Óµ ......
Õ⼸ÌìÊÖÍ·¿ª·¢µÄϵͳҪ×öÒ»¸öÀàËÆwindowsÕË»§µ½ÆÚʱ¼äµÄ¹¦ÄÜ£¬¿¼ÂÇÁË°ëÌìÏë³öÁËÒ»¸ö¼¼ÊõÉϺÍÂß¼É϶¼»¹ÄÜʵÏֵĽâ¾ö·½°¸£º
´´½¨Ò»¸öÓû§´æÈëÊý¾Ý¿âµÄʱºò¶¼´´½¨Ò»¸öʼþµ÷¶ÈÆ÷À´¿ØÖÆÓû§µÄµ½ÆÚʱ¼ä£¨mysqlµÄʱ¼äµ÷¶ÈÆ÷ȷʵºÜ·½±ã£©¡£ÏëÆðÀ´ÊǺܼòµ¥£¬µ«ÊÇ×öÆðÀ´ÎÊÌâȷʵһ²¨½ÓÒ»²¨...
һЩСÎÊÌâ¾Í²» ......