ÈçºÎÓÃ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±ê¼Ç¡¡£®£®£®
Ïà¹ØÎĵµ£º
×¼±¸¹¤×÷£ºÊý¾ÝÇåÏ´¡£¼ì²éÊý¾ÝÀàÐͺͱíÖеÄ×Ö¶ÎÀàÐÍÊÇ·ñÆ¥Å䣻¼ì²é¿ÕÖµÔ¼Êø£»È¥Î޹ؿոñµÈ¡£ÕâЩ¼ì²é¹¤×÷¿ÉÒÔͨ¹ýExcelµÄÊý¾Ýɸѡ¹¦ÄÜ£¬¿´Ò»ÏÂÿ¸ö×Ö¶ÎËùÓеÄÖµ£¬ÔÙÑ¡Öв»ºÏ¹æ·¶µÄ½øÐÐÐ޸ġ£
²½Ö裺
1£©µÇ¼pl/sql developer£¬µÇ¼ʱѡÔñ´ýµ¼Èë±íËùÔÚÊý¾Ý¿â£¬ÔÚ²éѯ´°¿ÚÀïÊäÈësele ......
SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â
/*·þÎñÆ÷½ÇÉ«*/
sysadmin
--ÔÚ SQL Server ÖнøÐÐÈκλ¡£¸Ã½ÇÉ«µÄȨÏÞ¿çÔ½ËùÓÐÆäËü¹Ì¶¨·þÎñÆ÷½ÇÉ«¡£
serveradmin
--ÅäÖ÷þÎñÆ÷·¶Î§µÄÉèÖá£
setupadmin
--Ìí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷£¬²¢Ö´ÐÐijЩϵͳ´æ´¢¹ý³Ì£¨Èç sp_serveroption£©¡£
securityadmin
--¹ÜÀí·þÎñÆ÷ ......
--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÄêÔÂÈÕ
select convert(varchar(10),getDate(),120)
--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÊ±·ÖÃë
select convert(varchar(8),getDate(),8)
Convertº¯ÊýµÄһЩ˵Ã÷£¬ÒÔÏÂ×ÊÁÏÀ´Ô´ÓÚÍøÂç
²»´øÊÀ¼ÍÊýλ (yy)
´øÊÀ¼ÍÊýλ (yyyy)
±ê×¼
ÊäÈë ......
1¡¢²éÕÒÔ±¹¤µÄ±àºÅ¡¢ÐÕÃû¡¢²¿ÃźͳöÉúÈÕÆÚ£¬Èç¹û³öÉúÈÕÆÚΪ¿ÕÖµ£¬ÏÔʾÈÕÆÚ²»Ïê,²¢°´²¿ÃÅÅÅÐòÊä³ö,ÈÕÆÚ¸ñʽΪyyyy-mm-dd¡£
select
emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),'ÈÕÆÚ²»Ïê') birthday
from employee
order by dept
¡¡¡¡
2¡¢²éÕÒÓëÓ÷×ÔÇ¿ÔÚͬһ¸öµ¥Î»µÄÔ±¹¤ÐÕÃû¡¢ÐÔ±ð¡ ......