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

sqlÖ®×óÁ¬½Ó¡¢ÓÒÁ¬½Ó¡¢È«Á¬½Ó

ÎÒÃǽéÉÜÁ˱íÁ¬½Ó£¬¸üÈ·ÇеÄ˵ÊÇinner joins內Á¬½Ó¡£內Á¬½Ó½öÑ¡³öÁ½ÕűíÖл¥ÏàÆ¥ÅäµÄ¼Ç¼£®Òò´Ë£¬Õâ»áµ¼ÖÂÓÐʱÎÒÃÇÐèÒªµÄ¼Ç¼ûÓаüº¬½øÀ´¡£
Ϊ¸üºÃµÄÀí½âÕâ¸ö¸ÅÄÎÒÃǽéÉÜÁ½¸ö±í×÷ÑÝʾ¡£ËÕ¸ñÀ¼Òé»áÖеÄÕþµ³±í(party)ºÍÒéÔ±±í(msp)¡£
 
party(Code,Name,Leader)
Code: Õþµ³´úÂë
Name: Õþµ³Ãû³Æ
Leader: Õþµ³ÁìÐä
 
msp(Name,Party,Constituency)
Name: ÒéÔ±Ãû
Party: ÒéÔ±ËùÔÚÕþµ³´úÂë
Constituency: Ñ¡Çø
ÔÚ½éÉÜ×óÁ¬½Ó¡¢ÓÒÁ¬½ÓºÍÈ«Á¬½Óǰ£¬ÓÐÒ»¸öÊý¾Ý¿âÖÐÖØÒªµÄ¸ÅÄîÒª½éÉÜһϣ¬¼´¿ÕÖµ(NULL)¡£ÓÐʱ±íÖУ¬¸üÈ·ÇеÄ˵ÊÇijЩ×Ö¶ÎÖµ£¬¿ÉÄÜ»á³öÏÖ¿ÕÖµ, ÕâÊÇÒòΪÕâ¸öÊý¾Ý²»ÖªµÀÊÇʲôֵ»ò¸ù±¾¾Í²»´æÔÚ¡£
¿ÕÖµ²»µÈͬÓÚ×Ö·û´®ÖеĿոñ£¬Ò²²»ÊÇÊý×ÖÀàÐ͵Ä0¡£Òò´Ë£¬ÅжÏij¸ö×Ö¶ÎÖµÊÇ·ñΪ¿Õֵʱ²»ÄÜʹÓÃ=,<>ÕâЩÅжϷû¡£±ØÐèÓÐרÓõĶÌÓIS NULL À´Ñ¡³öÓпÕÖµ×ֶεļǼ£¬Í¬Àí£¬¿ÉÓà IS NOT NULL Ñ¡³ö²»°üº¬¿ÕÖµµÄ¼Ç¼¡£
ÀýÈ磺ÏÂÃæµÄÓï¾äÑ¡³öÁËûÓÐÁìµ¼ÕßµÄÕþµ³¡££¨²»ÒªÆæ¹Ö£¬ËÕ¸ñÀ¼Òé»áÖÐȷʵ´æÔÚÕâÑùµÄÕþµ³£©
 
SELECT code, name from party
WHERE leader IS NULL
ÓÖÈ磺һ¸öÒéÔ±±»¿ª³ý³öµ³£¬¿´¿´ËûÊÇË­¡£(¼´¸ÃÒéÔ±µÄÕþµ³Îª¿ÕÖµ)
 
SELECT name from msp
WHERE party IS NULL
ºÃÁË£¬ÈÃÎÒÃÇÑÔ¹éÕý´«£¬¿´¿´Ê²Ã´½Ð×óÁ¬½Ó¡¢ÓÒÁ¬½ÓºÍÈ«Á¬½Ó¡£A left join£¨×óÁ¬½Ó£©°üº¬ËùÓеÄ×ó±ß±íÖеļǼÉõÖÁÊÇÓұ߱íÖÐûÓкÍËüÆ¥ÅäµÄ¼Ç¼¡£Í¬Àí£¬Ò²´æÔÚ×ÅÏàͬµÀÀíµÄ right join£¨ÓÒÁ¬½Ó£©£¬¼´°üº¬ËùÓеÄÓұ߱íÖеļǼÉõÖÁÊÇ×ó±ß±íÖÐûÓкÍËüÆ¥ÅäµÄ¼Ç¼¡£
¶øfull join(È«Á¬½Ó)¹ËÃû˼Ò壬×óÓÒ±íÖÐËùÓмǼ¶¼»áÑ¡³öÀ´¡£½²µ½ÕâÀÓÐÈË¿ÉÄÜÒªÎÊ£¬µ½µ×ʲô½Ð£º°üº¬ËùÓеÄ×ó±ß±íÖеļǼÉõÖÁÊÇÓұ߱íÖÐûÓкÍËüÆ¥ÅäµÄ¼Ç¼¡£
ÎÒÃÇÀ´¿´Ò»¸öʵÀý£º
 
SELECT msp.name, party.name
from msp JOIN party ON party=code
Õâ¸öÊÇÎÒÃÇÉÏÒ»½ÚËùѧµÄJoin(×¢Ò⣺Ҳ½Ðinner join)£¬Õâ¸öÓï¾äµÄ±¾ÒâÊÇÁгöËùÓÐÒéÔ±µÄÃû×ÖºÍËûËùÊôÕþµ³¡£
ºÜÒź¶£¬ÎÒÃÇ·¢ÏָòéѯµÄ½á¹ûÉÙÁËÁ½¸öÒéÔ±£ºCanavan MSP, Dennis¡£ÎªÊ²Ã´£¬ÒòΪÕâÁ½¸öÒéÔ±²»ÊôÓÚÈκÎÕþµ³£¬¼´ËûÃǵÄÕþµ³×Ö¶Î(Party)Ϊ¿ÕÖµ¡£ÄÇôΪʲô²»ÊôÓÚÈκÎÕþµ³¾Í²é²»³öÀ´ÁË£¿ÕâÊÇÒòΪ¿ÕÖµÔÚ×÷ ¹Ö¡£ÒòΪÒéÔ±±íÖÐÕþµ³×Ö¶Î(Party)µÄ¿ÕÖµÔÚÕþµ³±íÖÐÕÒ²»µ½¶ÔÓ¦µÄ¼Ç¼×÷Æ¥Å䣬¼´from msp JOIN party ON party=code¡¡Ã»ÓаѸüǼÁ¬½ÓÆðÀ´£¬¶øÊǹýÂ˳öÈ¥ÁË¡£ÔڸöÌÓïÖУ¬mspÔÚJo


Ïà¹ØÎĵµ£º

½â¾ö°²×°SQL Server2000 Îļþ¹ÒÆð

      1.²»ÓÃÍ˳öSQL2000°²×°³ÌÐò,Ö±½ÓÇл»µ½×ÀÃæ.
¡¡¡¡2.´ò¿ª×¢²á±í±à¼­Æ÷£¨ÔÚ“ÔËÐДÖÐÇÃÈë“regedit”Ö®ºó»Ø³µ¼´¿É£©£¬¶¨Î»µ½×¢²á±íµÄHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager½Úµã.
¡¡¡¡3.µ¥»÷“Session Manager”Õâ¸ö½Úµã£¬ ......

SQL Server2005 SynonymµÄʹÓÃ

--> Title  : SQL Server2005 SynonymµÄʹÓÃ
--> Author : wufeng4552
--> Date   : 2009-10-30
1.SynonymµÄ¸ÅÄî
¡¡  Synonym£¨Í¬Òå´Ê£©ÊÇSQL Server 2005µÄÐÂÌØÐÔ¡£¿ÉÒÔ¼òµ¥µÄÀí½âSynonymΪÆäËû對ÏóµÄ±ðÃû¡£
語·¨
CREATE SYNONYM [ schema_name_1. ] synonym_name FOR & ......

SQL ServerÖлã×ܹ¦ÄܵÄʹÓÃGROUPING,ROLLUPºÍCUBE

1.Óà CUBE »ã×ÜÊý¾Ý
 CUBE ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÊǶàάÊý¾Ý¼¯¡£¶àάÊý¾Ý¼¯ÊÇÊÂʵÊý¾ÝµÄÀ©Õ¹£¬ÊÂʵÊý¾Ý¼´¼Ç¼¸ö±ðʼþµÄÊý¾Ý¡£À©Õ¹½¨Á¢ÔÚÓû§´òËã·ÖÎöµÄÁÐÉÏ¡£ÕâЩÁб»³ÆÎªÎ¬¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸ö½á¹û¼¯£¬ÆäÖаüº¬Á˸÷ά¶ÈµÄËùÓпÉÄÜ×éºÏµÄ½»²æ±í¸ñ¡£ CUBE ÔËËã·ûÔÚ SELECT Óï¾äµÄ GROUP BY ×Ó¾äÖÐÖ¸¶¨¡£¸ÃÓï¾äµÄÑ¡ÔñÁбíÓ ......

ÕâÑùµÄsql£¬ÎÒÈ´×öµ½ÁË¡£

 ÕâÊÇÒ»¸öCSDN Oracle¿ª·¢°æ¿éÀï£¬ÍøÓÑÎʹýµÄÒ»µÀÌâ
ÌâÈçÏÂ
create table A_TEST
(
PAYOUT_ITEM_CODE VARCHAR2(30) not
null,
FORMULA_DET VARCHAR2(1000)
)
create table B_TEST
(
ELEMENT_ID VARCHAR2(5) not null,
NAME VARCHAR2(41)
)  
Çóдoracle¶à¸ö×Ö·ûÌæ»»£¨ÓвâÊÔÊý¾Ý£©
inser ......

SQLÌæ»»Ö¸¶¨ÁÐ×Ö·û´®

 -- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comm ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ