Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Server 2000 Êý¾Ý¿âͬ²½

SQL Server 2000 Êý¾Ý¿âͬ²½ÅäÖõÄÔ­Àí
¸´ÖƵĸÅÄî
Microsoft? SQL Server? 2000 µÄ¸´ÖÆÊÇÔÚÊý¾Ý¿âÖ®¼ä¶ÔÊý¾ÝºÍÊý¾Ý¿â¶ÔÏó½øÐи´ÖÆ
ºÍ·Ö·¢²¢½øÐÐͬ²½ÒÔÈ·±£ÆäÒ»ÖÂÐÔµÄÒ»×é¼¼Êõ¡£
ʹÓø´ÖÆ¿ÉÒÔ½«Êý¾Ý·Ö·¢µ½²»Í¬Î»Öã¬Í¨¹ý¾ÖÓòÍø¡¢Ê¹Óò¦ºÅÁ¬½Ó¡¢Í¨¹ý Internet ·Ö
·¢¸øÔ¶³Ì»òÒƶ¯Óû§¡£¸´ÖÆ»¹Äܹ»Ê¹Óû§Ìá¸ßÓ¦ÓóÌÐòÐÔÄÜ£¬¸ù¾ÝÊý¾ÝµÄʹÓ÷½Ê½ÎïÀí
·Ö¸ôÊý¾Ý£¨ÀýÈ磬½«Áª»úÊÂÎñ´¦Àí (OLTP) ºÍ¾ö²ßÖ§³Öϵͳ·Ö¿ª£©£¬»òÕß¿çÔ½¶à¸ö·þÎñ
Æ÷·Ö²¼Êý¾Ý¿â´¦Àí¡£
---------------------------------------------------------------------------
SQL¸´ÖƵĻù±¾ÔªËØ°üÀ¨
·¢²¼·þÎñÆ÷¡¢¶©ÔÄ·þÎñÆ÷¡¢·Ö·¢·þÎñÆ÷¡¢·¢²¼¡¢ÏîÄ¿
·¢²¼·þÎñÆ÷
·¢²¼·þÎñÆ÷ÊÇÌṩÊý¾ÝÒԱ㸴ÖƵ½ÆäËü·þÎñÆ÷µÄ·þÎñÆ÷¡£·¢²¼·þÎñÆ÷¿ÉÒÔ¾ßÓÐÒ»¸ö»ò¶à¸ö
·¢²¼£¬Ã¿¸ö·¢²¼´ú±íÒ»×éÂß¼­Ïà¹ØµÄÊý¾Ý¡£³ýÁËÖ¸¶¨ÆäÖÐÄÄЩÊý¾ÝÐèÒª¸´ÖÆÖ®Í⣬·¢²¼·þ
ÎñÆ÷»¹¼ì²âÊÂÎñ¸´ÖÆÆڼ䷢Éú¸ü¸ÄµÄÊý¾Ý²¢Î¬»¤ÓйشËÕ¾µãÉÏËùÓз¢²¼µÄÐÅÏ¢¡£
·Ö·¢·þÎñÆ÷
·Ö·¢·þÎñÆ÷ÊÇ×÷Ϊ·Ö·¢Êý¾Ý¿âËÞÖ÷²¢´æ´¢ÀúÊ·Êý¾ÝºÍ/»òÊÂÎñÒÔ¼°ÔªÊý¾ÝµÄ·þÎñÆ÷¡£·Ö·¢
·þÎñÆ÷µÄ½ÇÉ«¸ù¾ÝÖ´Ðеĸ´ÖÆÀàÐͶø²»Í¬¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼û¸´ÖÆÀàÐÍ¡£
Ô¶³Ì·Ö·¢·þÎñÆ÷ÊǶÀÁ¢ÓÚ·¢²¼·þÎñÆ÷²¢ÅäÖÃΪ¸´ÖƵķַ¢·þÎñÆ÷µÄ·þÎñÆ÷¡£±¾µØ·Ö·¢·þÎñ
Æ÷ÊǼÈÅäÖÃΪ¸´ÖƵķ¢²¼·þÎñÆ÷ÓÖÅäÖÃΪ¸´ÖƵķַ¢·þÎñÆ÷µÄ·þÎñÆ÷¡£
¶©ÔÄ·þÎñÆ÷
¶©ÔÄ·þÎñÆ÷ÊǽÓÊÕ¸´ÖÆÊý¾ÝµÄ·þÎñÆ÷¡£¶©ÔÄ·þÎñÆ÷¶©ÔĵÄÊÇ·¢²¼¶ø²»ÊÇ·¢²¼ÖзÖÀëµÄÏîÄ¿£»
²¢ÇÒ¶©ÔÄ·þÎñÆ÷Ö»¶©ÔÄÆäÐèÒªµÄ·¢²¼£¬¶ø²»ÊÇ·¢²¼·þÎñÆ÷ÉÏËùÓпÉÓõķ¢²¼¡£¸ù¾Ý¸´ÖƵÄÀà
ÐͺÍËùÑ¡ÔñµÄ¸´ÖÆÑ¡Ï¶©ÔÄ·þÎñÆ÷»¹¿ÉÒÔ½«Êý¾Ý¸ü¸Ä´«²¥»Ø·¢²¼·þÎñÆ÷»ò½«Êý¾ÝÖØз¢²¼
µ½ÆäËü¶©ÔÄ·þÎñÆ÷¡£
·¢²¼
·¢²¼ÊÇÒ»¸öÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öÏîÄ¿µÄ¼¯ºÏ¡£ÕâÖÖ¶à¸öÏîÄ¿µÄ·Ö×éʹµÃÖ¸¶¨Âß¼­Ïà¹ØµÄÒ»
×éÊý¾ÝºÍÊý¾Ý¿â¶ÔÏóÒÔÒ»Æð¸´ÖƱäµÃ¸üÈÝÒס£
씀ÏîÄ¿ÊÇÖ¸¶¨Òª¸´ÖƵÄÊý¾Ý±í¡¢Êý¾Ý·ÖÇø»òÊý¾Ý¿â¶ÔÏó¡£ÏîÄ¿¿ÉÒÔÊÇÍêÕûµÄ±í¡¢Ä³¼¸ÁУ¨Ê¹Óô¹
ֱɸѡ£©¡¢Ä³¼¸ÐУ¨Ê¹ÓÃˮƽɸѡ£©¡¢´æ´¢¹ý³Ì»òÊÓͼ¶¨Òå¡¢´æ´¢¹ý³ÌµÄÖ´ÐС¢ÊÓͼ¡¢Ë÷ÒýÊÓͼ
»òÓû§¶¨Ò庯Êý¡£
¶©ÔÄ
¶©ÔÄÊǶÔÊý¾Ý»òÊý¾Ý¿â¶ÔÏóµÄ¸´±¾µÄÇëÇ󡣶©ÔĶ¨Ò彫½ÓÊյķ¢²¼ºÍ½ÓÊÕµÄʱ¼ä¡¢µØµã¡£¶©ÔĵÄ
ͬ²½»òÊý¾Ý·Ö·¢¿ÉÒÔÓÉ·¢²¼·þÎñÆ÷£¨Ç¿Öƶ©ÔÄ£©»ò¶©ÔÄ·þÎñÆ÷£¨ÇëÇó¶©ÔÄ£©ÇëÇó¡£·¢²¼¿ÉÒÔÖ§³Ö
Ç¿Öƶ©ÔĺÍÇëÇó¶©ÔĵĻìºÏ¡£
-----------------------------------------------------------------------


Ïà¹ØÎĵµ£º

SQL »ù±¾½¨±íÓï¾ä

×÷Ϊ±¸Íü°É.ÔÚ»ú·¿ÀïÊäÈëµÄ.
/*CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
 Sname CHAR(20) UNIQUE,
 Ssex CHAR(2),
 Sage SMALLINT,
 Sdept CHAR(20)
);*/
/*CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
 Cname CHAR(40),
 Cpno CHAR(4),
 Credit SMALLINT,
&n ......

sql ±íÐÞ¸ÄÁÐ

 create table #a
(
a int identity(1,1) primary key,
b int default(0) not null,
c nvarchar(20)
)
insert into #a(c)
select 'a' union all
select 'b' union all
select 'c' union all
select 'd' union all
select 'e'
select * from #a
alter table #a drop constraint DF__#a_____________b__12 ......

Oracle SQLÓï¾ä

ORDER BY ÅÅÐò
 
ASC ÉýÐò(ĬÈÏ)
 DESC ½µÐò
 
select * from s_emp order by dept_id , salary desc
²¿ÃźÅÉýÐò£¬¹¤×ʽµÐò
¹Ø¼ü×ÖdistinctÒ²»á´¥·¢ÅÅÐò²Ù×÷¡£
 
select * from employee order by 1; //°´µÚÒ»×Ö¶ÎÅÅÐò
NULL±»ÈÏΪÎÞÇî´ó¡£order by ¿ÉÒÔ¸ú±ðÃû¡£
 
select table_name ......

SQL ×óÍâÁ¬½Ó£¬ÓÒÍâÁ¬½Ó£¬È«Á¬½Ó£¬ÄÚÁ¬½Ó

 Áª½ÓÌõ¼þ¿ÉÔÚ   from   »ò   WHERE   ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ   from   ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE   ºÍ   HAVING   ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£   
   
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ      ......

Sql Server·¢ÓʼþÅäÖÃ

¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾ­ÕýÈ·ÅäÖá£
    £¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
     ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ