SQL Server2005ÖеÄSQL ServerÉí·ÝÑéÖ¤µÄÉèÖÃ
	
    
    
	
¸Õ¸Õ×°ÁËSQL2008£¬ÅäÖÃÁËһϣ¬ÔÚÍøÉÏÕÒµ½Õâ¸ö½Ì³Ì£¬¾õµÃ²»´í£¬×ªÔØÑ§Ï°
1¡¢ ¸ü¸ÄTCP/IPÁ¬½ÓΪÆôÓÃ
2¡¢ µÇ¼ £¬ ÐÞ¸Ä2¸öµØ·½
    a) Éí·ÝÑéÖ¤·½Ê½£¨»ìºÏģʽ£©
        ͼһ£ºÊ×ÏÈʹÓÃwindowsÉí·ÝµÇ¼£¨×¢Ò⣬ ·þÎñÆ÷Ãû³Æ±ØÐëÌîдÕýÈ·£©
        ͼ¶þ£º´ò¿ªSQL ʵÀýµÄÊôÐÔ
        ͼÈý£ºÑ¡Ôñ×ó±ßµÄ“°²È«ÐÔ”£¬ ×¢Òâ×öÈçÏÂÑ¡Ôñ
    b) ÆôÓÃsa£¬ Èô½«saµÄÃÜÂëÉèÖÃΪ¿ÕÃÜÂ룬 Ìø¹ýµÚÒ»²½£» ÈôÃÜÂ벻Ϊ¿Õ£¬ Á½²½Í¬Ê±ÉèÖ㬠¼´£º2¸ö¶¼ÉèÖÃÍê³Éºóµã»÷È·¶¨¼´¿É¡£
        i. µÚÒ»²½£¬ ÆôÓÃSa
        ¸ü¸ÄÍê³Éºó£¬µ¥»÷È·¶¨±£´æ
        ii. µÚ¶þ²½£¬ÉèÖÃÃÜÂë
¸ü¸ÄÍê³Éºó£¬µ¥»÷È·¶¨±£´æ
µ±È»Õû¸öÉèÖÃÍê³ÉÖ®ºó£¬ »¹ÐèÒªÖØÆôsql·þÎñ£¬Èç¹û»¹²»ÐУ¬ÔÙÈ¥¿ØÖÆÃæ°å£¬¹ÜÀí¹¤¾ß£¬·þÎñÖÐÕÒµ½SQL Server (MSSQLSERVER)ÏÈÍ£Ö¹£¬ÔÙÆô¶¯£¬È»ºóÔÙÖØÐÂÆô¶¯SQL£¬Ó¦¸ÃûÎÊÌâÁË£¡
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    1¡¢²é¿´µ±Ç°Êý¾Ý¿âµÄ״̬
       SELECT
 DATABASEPROPERTY
 ('pubs'
,'IsFulltextEnabled'
)
 2¡¢´ò¿ªFullText¹¦ÄÜ
       sp_fulltext_databse
 'enable'
       ¹Ø±Õ´Ë¹¦ÄÜ
     & ......
	
    
        
    
    
Ò»¡¢Ç°ÑÔ
“ÈËÀàʧȥËÑË÷£¬ÊÀ½ç½«»áÔõÑù?”£¬Í¬Ñù£¬ºÜÄÑÏëÏóÒ»¸öÓµÓм«´óÐÅÏ¢Á¿µÄÐÐÒµÍøÕ¾ÃÅ»§Ã»ÓÐÕ¾ÄÚÈ«ÎÄËÑË÷½«»á³öÏÖÔõÑùµÄ¾ÖÃæ£¬ÍøÕ¾È«ÎļìË÷¶ÔÓÚÍÚ¾òÍøÕ¾ÐÅÏ¢ºÍÕûºÏÍøÕ¾×ÊÔ´µÄ¼ÛÖµÊDz»ÑÔ¶øÓ÷µÄ¡£ÎÒÃÇ¿´µ½£¬Í¨ÓÃÐ͵ÄËÑË÷ÒýÇæÒѾ³ÉΪÁË»¥ÁªÍøÊÀ½çµÄÃÅ»§£¬¶ø¶ÔÓÚÒ»¸öÐÅÏ¢Á¿¼«Æä·á¸»µÄÍøÕ¾¶øÑÔ£¬È«ÍøËÑË÷»òÐ ......
	
    
        
    
    select count(1) from dictionary;
select * from dba_data_files;
select count(1) from dba_objects t where t.owner='BESTTONE';
select * from dba_tablespaces t where t.tablespace_name='BESTTONE';
select count(1) from dba_tables t where t.owner='BESTTONE';
select t.table_name,t.comments from diction ......
	
    
        
    
    SQLÓï¾äµ¼Èëµ¼³ö´óÈ«[ÊÕ¼¯]
ÕýÇÉÕâÁ½ÌìÒªÓõ½Õâ¸ö£¬ÉÏÍøÕÒµ½Ò»¸ö£¬»ØÀ´×Ô¼º¼ì²âһϣº
/******* µ¼³öµ½excel
EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -
S"GNETDATA/GNETDATA" -U"sa" -P""'
/*********** µ¼ÈëExcel
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
 ......
	
    
        
    
    
µÚÒ»²¿·Ö£ºoracle pl/sqlʵÀýÁ·Ï°(1)
Ò»¡¢Ê¹ÓÃscott/tigerÓû§ÏµÄemp±íºÍdept±íÍê³ÉÏÂÁÐÁ·Ï°£¬±íµÄ½á¹¹ËµÃ÷ÈçÏÂ
empÔ±¹¤±í(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
dept²¿Ãűí(deptno²¿ÃűàºÅ/dname²¿ÃÅÃû³Æ/locµØµã) 
¹¤×Ê £½ н½ð £« Ó¶½ð
Ò²¿ÉÒÔͨ¹ý ......