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

ÈçºÎÓÃSQL Óï¾ä¶ÁÈ¡DÅÌÄÚÈÝ

master..xp_dirtree   'D:\',1,1        µÚÒ»¸ö1ÊÇÉî¶È£¬µÚ¶þ¸ö1ÊÇÎļþ
1.   Ö´ÐÐ   master..xp_dirtree   'c:\',1,1,ÕâÑù¿ÉÒÔ»ñÈ¡c:\ϵÄËùÓÐÎļþºÍÎļþ¼Ð,²»°üÀ¨×ÓÎļþ¼Ð¼°Îļþ   
   
2.   ÏÔʾÔÚtreeviewÖÐ,ÓñêÖ¾Çø±ðÎļþÓëĿ¼   
   
3.   ΪËùÓеÄĿ¼´´½¨Ò»¸öÒþ²ØµÄ×Ó½áµã(ÕâÑùĿ¼¾ÍÓÐÁË+,¿ÉÒÔÕ¹¿ª)   
   
4.   Èç¹ûÓû§Õ¹¿ªÄ³¸öĿ¼,ÄÇô¼ì²éÕâ¸ö½áµãÏÂÊÇ·ñÓÐÒ»¸öÒþ²ØµÄ×Ó½áµã,Èç¹ûÓбíʾ´ÓÀ´Ã»Óд¦Àí¹ý.  
        µ÷ÓÃ   master..xp_dirtree   'c:\<path>',1,1    
        ÆäÖÐpathÊǵ±Ç°µÄĿ¼ÃûÀ´µÃµ½Óû§ÒªÕ¹¿ªµÄĿ¼ÏµĵÚÒ»²ãÎļþºÍÎļþ¼Ð.   ²¢Ìí¼Óµ½treeviewÖÐ,ͨ²Å²½Öè2,3µÄ´¦Àí  
        Èç¹ûÓû§Õ¹¿ªµÄÊÇÒѾ­´¦Àí¹ýµÄĿ¼,ÔòÎÞ·¨´¦Àí.  
£±£®ÏȽ«Óá¡master..xp_dirtree   'c:\',0,1¡¡½«ËùÓÐÎļþÈ¡³öÀ´£¬  
£²£®È»ºó½«depth   =   1µÄÑ¡Ôñ³öÀ´×÷Ϊ£ÃÅ̸ùĿ¼ÏµÄĿ¼¼°ÎļþÃû  
£³£®ÔÙÓÃÑ­»·Óï¾ä½«¼ÌÐøËÑË÷£¬ÀýÈç¡¡master..xp_dirtree   'c:\Windows',0,1,    
  ¡¡Í¬Ê±ÎªËÑË÷³öÀ´µÄÎļþ¼ÓÉÏParent±ê¼Ç¡¡£®£®£®  


Ïà¹ØÎĵµ£º

SQL²Ù×÷È«¼¯

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......

SQL ServerºÍMySQLÖÐTopÓ÷¨µÄÇø±ð

      ½ñÌìÁ·Ï°ÔÚJSPÒ³ÃæÖÐʵÏÖ·ÖҳЧ¹û£¬ÔÚ²éѯÓï¾ä·½ÃæÇ£³¶µ½ÁËtopµÄÓ÷¨¡£¼òÒª×öÒ»ÏÂ×ܽ᣺
      ΪʵÏÖÀàËÆtopµÄ¹¦ÄÜ£¬ÎÒÃÇÔÚSQL ServerÖкÍMySQLÖÐʹÓõ½µÄSQLÓï¾äÊDz»Í¬µÄ¡£
      1¡¢ÔÚSQL ServerÖУ¬ÎÒÃÇʹÓà select top N * ......

Sql Server ²éѯsqlÖ´Ðи÷¸ö½×¶ÎµÄʱ¼ä

Sql Server ²éѯsqlÖ´Ðи÷¸ö½×¶ÎµÄʱ¼ä
set statistics io on
set statistics time on
set statistics profile on
go
[ÄãµÄsqlÓï¾ä]
go
set statistics io off
set statistics time off
set statistics profile off

ÎÒÔËÐУº
set statistics io on
set statistics time on
set statistics profile on ......

SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â

SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â
/*·þÎñÆ÷½ÇÉ«*/
sysadmin
--ÔÚ SQL Server ÖнøÐÐÈκλ¡£¸Ã½ÇÉ«µÄȨÏÞ¿çÔ½ËùÓÐÆäËü¹Ì¶¨·þÎñÆ÷½ÇÉ«¡£
serveradmin
--ÅäÖ÷þÎñÆ÷·¶Î§µÄÉèÖá£
setupadmin
--Ìí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷£¬²¢Ö´ÐÐijЩϵͳ´æ´¢¹ý³Ì£¨Èç sp_serveroption£©¡£
securityadmin
--¹ÜÀí·þÎñÆ÷ ......

50ÖÖ·½·¨ÇÉÃîÓÅ»¯ÄãµÄSQL ServerÊý¾Ý¿â

²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
¡¡¡¡
¡¡¡¡1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
¡¡¡¡
¡¡¡¡2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
¡¡¡¡
¡¡¡¡3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
¡¡¡¡
¡¡¡¡4¡¢ÄÚ´æ²»×ã
¡¡¡¡
¡¡¡¡5¡¢ÍøÂçËÙ¶ÈÂý
¡¡¡¡
¡¡¡¡6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó£¨¿ÉÒÔ²ÉÓöഠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ