ÍâÁ¬½ÓsqlµÄÒ»¸öÎÊÌâ
	
    
    
	µ±ÔÚÄÚÁ¬½Ó²éѯÖмÓÈëÌõ¼þʱ£¬ÎÞÂÛÊǽ«Ëü¼ÓÈëµ½join×Ӿ䣬»¹ÊǼÓÈëµ½where×Ӿ䣬ÆäЧ¹ûÊÇÍêȫһÑùµÄ£¬µ«¶ÔÓÚÍâÁ¬½ÓÇé¿ö¾Í²»Í¬ÁË¡£µ±°ÑÌõ¼þ¼ÓÈëµ½ join×Ó¾äʱ£¬»á·µ»ØÍâÁ¬½Ó±íµÄÈ«²¿ÐУ¬È»ºóʹÓÃÖ¸¶¨µÄÌõ¼þ·µ»ØµÚ¶þ¸ö±íµÄÐС£Èç¹û½«Ìõ¼þ·Åµ½where×Ó¾äÖУ¬½«»áÊ×ÏȽøÐÐÁ¬½Ó²Ù×÷£¬È»ºóʹÓÃwhere×Ó¾ä¶ÔÁ¬½ÓºóµÄÐнøÐÐɸѡ¡£ÀýÈ磺
£¨1£©
select u.id, u.p_plan_id, u.unit_name, p.id, p.plan_name
  from t_baidu_p_units u
  left outer join t_baidu_p_plans p on u.p_plan_id = p.id
                                   and p.id = 3176
 where 1 = 1
 order by u.p_plan_id desc
Ëü»á·µ»Øt_baidu_p_units±íÖÐËùÓÐÐУ¬t_baidu_p_plans±íÖзûºÏjoinÌõ¼þµÄ×ֶβ»Îªnull
£¨2£©
select u.id, u.p_plan_id, u.unit_name, p.id, p.plan_name
  from t_baidu_p_units u
  left outer join t_baidu_p_plans p on u.p_plan_id = p.id
                                   and p.id = 3176
 where p.id is null
 order by u.p_plan_id desc
²éѯµÄ½á¹û¼¯ÖÐûÓзûºÏjoinÌõ¼þµÄÊý¾Ý
£¨3£©
select u.id, u.p_plan_id, u.unit_name, p.id, p.plan_name
  from t_baidu_p_units u
  left outer join t_baidu_p_plans p on u.p_plan_id = p.id
                                   and p.id = 3176
 where p.id is not null
 order by u.p_plan_id desc
½á¹û¼¯ÖÐÖ»°üº¬joinÌõ¼þµÄÊý¾Ý
·ÖÎöһϣº
  £¨1£©where1=1¶ÔÆä½øÐйýÂËʱ£¬ÓÉÓÚ¶¼·ûºÏ´ËÌõ¼þ£¬Òò´ËûÓиıä½á¹û¼¯
  £¨2£©¸ù¾Ýwhere p.id is null¶ÔÓÚjoinºóµÄ½á¹û¼¯½øÐÐɸѡ£¬·²ÊÇp.id²»ÎªnullµÄ¶¼Òª¹ýÂ˵ô£¬Òò´Ë×ÔȻûÓÐp.id=3176µÄ½á¹û
  £¨
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    
±ÈÈçÔÚNorthwindÊý¾Ý¿âÖÐ 
ÓÐÒ»¸ö²éѯΪ 
SELECT c.CustomerId, CompanyName 
from Customers c 
WHERE EXISTS( 
SELECT OrderID from Orders o 
WHERE o.CustomerID = cu.CustomerID) 
ÕâÀïÃæµÄEXISTSÊÇÈçºÎÔË×÷ÄØ£¿×Ó²éѯ·µ»ØµÄÊÇOrderId×ֶΣ¬¿ÉÊÇÍâÃæµÄ²éѯҪÕÒµÄÊÇCustomerIDºÍCompanyName×ֶΣ¬ÕâÁ½¸ö×Ö¶Î¿Ï ......
	
    
        
    
    ORACLE SQLÐÔÄÜÓÅ»¯ÏµÁÐ
 
1. ·ÃÎÊTableµÄ·½Ê½
ORACLE ²ÉÓÃÁ½ÖÖ·ÃÎʱíÖмǼµÄ·½Ê½: 
a. È«±íɨÃè 
È«±íɨÃè¾ÍÊÇ˳ÐòµØ·ÃÎʱíÖÐÿÌõ¼Ç¼. ORACLE²ÉÓÃÒ»´Î¶ÁÈë¶à¸öÊý¾Ý¿é(database block)µÄ·½Ê½ÓÅ»¯È«±íɨÃè. 
b. ͨ¹ýROWID·ÃÎʱí 
Äã¿ÉÒÔ²ÉÓûùÓÚROWIDµÄ·ÃÎÊ·½Ê½Çé¿ö,Ìá¸ß·ÃÎʱíµÄЧÂÊ, , ROWID°üº¬Á˱íÖмǼµ ......
	
    
        
    
    ÈçºÎÈ·¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾
Ҫȷ¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾£¬ÇëʹÓà SQL Server Management Studio Á¬½Óµ½ SQL Server 2005£¬È»ºóÔËÐÐÒÔÏ Transact-SQL Óï¾ä£º 
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
ÔËÐнá¹ûÈçÏ£º 
²úÆ·° ......
	
    
        
    
    ÓαêµÄÀàÐÍ£º
  1¡¢¾²Ì¬Óαê(²»¼ì²âÊý¾ÝÐеı仯£©
  2¡¢¶¯Ì¬Óα꣨·´Ó³ËùÓÐÊý¾ÝÐеĸı䣩
  3¡¢½öÏòǰÓα꣨²»Ö§³Ö¹ö¶¯£©
  4¡¢¼ü¼¯Óα꣨ÄÜ·´Ó³Ð޸쬵«²»ÄÜ׼ȷ·´Ó³²åÈ롢ɾ³ý£©
ÓαêʹÓÃ˳Ðò£º
   1¡¢¶¨ÒåÓαê
   2¡¢´ò¿ªÓαê
   3¡¢Ê¹ÓÃÓαê
   ......