Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±ê¼Ç¡¡£®£®£®  


Ïà¹ØÎĵµ£º

bulletedlist ¼Ó sql server ²É¼¯ÍøÕ¾µØÖ·

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{ ......

sql server 2005 imageÊý¾ÝÀàÐ͵ÄʹÓÃ

       ×î½ü×öÒ»¸öÏîÄ¿µÄʱºòÐèÒªÍùÊý¾Ý¿âÄÚ²åÈëͼƬ£¬ÉÏÍø²éÁËһϣ¬Ö÷ÒªÓÐÁ½ÖÖ·½·¨£¬µÚÒ»¾ÍÊÇÔÚÊý¾Ý¿âÖд洢ͼƬµÄ·¾¶£¬È»ºóÔÚ³ÌÐòÖиù¾Ý¶ÁÈ¡µÄ·¾¶¶ÁȡͼƬ£»ÕâÖÖ·½·¨¼òµ¥¡¢ÈÝÒ×ʹÓ㬵«ÊÇÔÚͼƬ¹ý¶àʱ²»ºÃ¹ÜÀí¡£
      µÚ¶þÖÖ¾ÍÊǽ«Í¼Æ¬×ª»»³É¶þ½øÖÆ´æ´¢ÓÚÊý ......

¼¸µÀ¾­µäµÄSQL±ÊÊÔÌâÄ¿

¼¸µÀ¾­µäµÄSQL±ÊÊÔÌâÄ¿£¨Óд𰸣©
£¨1£©±íÃû£º¹ºÎïÐÅÏ¢
¹ºÎïÈË      ÉÌÆ·Ãû³Æ     ÊýÁ¿
A            ¼×          2
B            ÒÒ     &n ......

35Ìõ»ù±¾SQLÓï¾ä

 1¡¢²éÕÒÔ±¹¤µÄ±àºÅ¡¢ÐÕÃû¡¢²¿ÃźͳöÉúÈÕÆÚ£¬Èç¹û³öÉúÈÕÆÚΪ¿ÕÖµ£¬ÏÔʾÈÕÆÚ²»Ïê,²¢°´²¿ÃÅÅÅÐòÊä³ö,ÈÕÆÚ¸ñʽΪyyyy-mm-dd¡£
select
emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),'ÈÕÆÚ²»Ïê') birthday
from employee
order by dept
 
¡¡¡¡
2¡¢²éÕÒÓëÓ÷×ÔÇ¿ÔÚͬһ¸öµ¥Î»µÄÔ±¹¤ÐÕÃû¡¢ÐÔ±ð¡ ......

³£ÓÃsqlÏà¹Ø

1Ð޸Ļù±¾±í
 Ìí¼ÓÁÐ alter table tableName add<ÐÂÁÐÃû><Êý¾ÝÀàÐÍ>[ÍêÕûÐÔÔ¼Êø]
 É¾³ýÁÐ alter table tableName drop<ÐÂÁÐÃû><Êý¾ÝÀàÐÍ>[ÍêÕûÐÔÔ¼Êø]
2´´½¨
  ½¨±ícreate table tableName(
id primary key AUTO_INCREMENT(mysql);
id primary key identity(1,1)(s ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ