ÈçºÎÓÃ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±ê¼Ç¡¡£®£®£®
Ïà¹ØÎĵµ£º
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Öд´½¨Óû§×Ô¶¨Ò寴Òôº¯Êý£º
create function f_GetPy(@Str nvarchar(400))
returns nvarchar(4000)
as
begin
declare @strlen int,@re nvarchar(4000)
declare @t table(chr nchar(1) collate Chinese_PRC_CI_AS,letter nchar(1))
insert @t select 'ß¹','A' union all select '°Ë','B'
union all select 'àê ......
½ñÌìÁ·Ï°ÔÚJSPÒ³ÃæÖÐʵÏÖ·ÖҳЧ¹û£¬ÔÚ²éѯÓï¾ä·½ÃæÇ£³¶µ½ÁËtopµÄÓ÷¨¡£¼òÒª×öÒ»ÏÂ×ܽ᣺
ΪʵÏÖÀàËÆtopµÄ¹¦ÄÜ£¬ÎÒÃÇÔÚSQL ServerÖкÍMySQLÖÐʹÓõ½µÄSQLÓï¾äÊDz»Í¬µÄ¡£
1¡¢ÔÚSQL ServerÖУ¬ÎÒÃÇʹÓà select top N * ......
ÎÄÕµ¼º½ SQL Server 2005 ѧϰ±Ê¼ÇϵÁÐÎÄÕµ¼º½
ÕâÒ»½ÚÔÛÃÇÀ´ËµËµClRµÄÐÔÄÜ£¬ÎÒÃDz»ÄÜֻʹÓÃËü¶ø²»È¥¿¼Âǵ½µÍ ΪʲôҪʹÓÃËü»òÊÇÔÚʲôʱºòÓ¦¸ÃʹÓÃËü£¬ÏñÎÒ֮ǰдµÄº¯ÊýµÃµ½Ò»¸ö×Ö·ûµÄ³¤¶ÈµÄ·½·¨¾ÍûÓÐÌ«´ó±ØÒªÁË£¬µ«Èç¹ûÊÇÏñ²ð·Ö×Ö·ûÕâÑùµÄ·½·¨Ó¦¸Ã¾ÍÓбØÒªÁË£¬±ÈÈçc#ÀïµÄSplit ......
1¡¢²éÕÒÔ±¹¤µÄ±àºÅ¡¢ÐÕÃû¡¢²¿ÃźͳöÉúÈÕÆÚ£¬Èç¹û³öÉúÈÕÆÚΪ¿ÕÖµ£¬ÏÔʾÈÕÆÚ²»Ïê,²¢°´²¿ÃÅÅÅÐòÊä³ö,ÈÕÆÚ¸ñʽΪyyyy-mm-dd¡£
select
emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),'ÈÕÆÚ²»Ïê') birthday
from employee
order by dept
¡¡¡¡
2¡¢²éÕÒÓëÓ÷×ÔÇ¿ÔÚͬһ¸öµ¥Î»µÄÔ±¹¤ÐÕÃû¡¢ÐÔ±ð¡ ......