SQL Server 2000 Êý¾Ý¿âͬ²½
SQL Server 2000 Êý¾Ý¿âͬ²½ÅäÖõÄÔÀí
¸´ÖƵĸÅÄî
Microsoft? SQL Server? 2000 µÄ¸´ÖÆÊÇÔÚÊý¾Ý¿âÖ®¼ä¶ÔÊý¾ÝºÍÊý¾Ý¿â¶ÔÏó½øÐи´ÖÆ
ºÍ·Ö·¢²¢½øÐÐͬ²½ÒÔÈ·±£ÆäÒ»ÖÂÐÔµÄÒ»×é¼¼Êõ¡£
ʹÓø´ÖÆ¿ÉÒÔ½«Êý¾Ý·Ö·¢µ½²»Í¬Î»Öã¬Í¨¹ý¾ÖÓòÍø¡¢Ê¹Óò¦ºÅÁ¬½Ó¡¢Í¨¹ý Internet ·Ö
·¢¸øÔ¶³Ì»òÒƶ¯Óû§¡£¸´ÖÆ»¹Äܹ»Ê¹Óû§Ìá¸ßÓ¦ÓóÌÐòÐÔÄÜ£¬¸ù¾ÝÊý¾ÝµÄʹÓ÷½Ê½ÎïÀí
·Ö¸ôÊý¾Ý£¨ÀýÈ磬½«Áª»úÊÂÎñ´¦Àí (OLTP) ºÍ¾ö²ßÖ§³Öϵͳ·Ö¿ª£©£¬»òÕß¿çÔ½¶à¸ö·þÎñ
Æ÷·Ö²¼Êý¾Ý¿â´¦Àí¡£
---------------------------------------------------------------------------
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 ......
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 ......
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 ......
Áª½ÓÌõ¼þ¿ÉÔÚ from »ò WHERE ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ from ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE ºÍ HAVING ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ   ......
¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾÕýÈ·ÅäÖá£
£¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......