查找文件的语句查找文件的语句.docxVIP

查找文件的语句

CODE:

droptabletmp;

createtabletmp

(

[id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](300)NOTNULL,

[depth][int]NOTNULL,

[isfile][nvarchar](50)NULL

);

declare@idint,@depthint,@rootnvarchar(300),@namenvarchar(300)

set@root=f:\usr\--Startroot

set@name=cmd.exe--Findfile

insertintotmpexecmaster..xp_dirtree@root,0,1--

set@id=(selecttop1idfromtmpwhereisfile=1andname=@name)

set@depth=(selecttop1depthfromtmpwhereisfile=1andname=@name)

while@depth1

begin

set@id=(selecttop1idfromtmpwhereisfile=0andid@idanddepth=(@depth-1)orderbyiddesc)

set@depth=(selectdepthfromtmpwhereid=@id)

set@name=(selectnamefromtmpwhereid=@id)+\+@name

end

updatetmpsetname=@root+@namewhereid=1

selectnamefromtmpwhereid=1

查找目录的语句

CODE:

droptabletmp;

createtabletmp

(

[id][int]IDENTITY(1,1)NOTNULL,

[name][nvarchar](300)NOTNULL,

[depth][int]NOTNULL

);

declare@idint,@depthint,@rootnvarchar(300),@namenvarchar(300)

set@root=f:\usr\--Startroot

set@name=donggeer--directorytofind

insertintotmpexecmaster..xp_dirtree@root,0,0

set@id=(selecttop1idfromtmpwherename=@name)

set@depth=(selecttop1depthfromtmpwherename=@name)

while@depth1

begin

set@id=(selecttop1idfromtmpwhereid@idanddepth=(@depth-1)orderbyiddesc)

set@depth=(selectdepthfromtmpwhereid=@id)

set@name=(selectnamefromtmpwhereid=@id)+\+@name

endupdatetmpsetname=@root+@namewhereid=1

selectnamefromtmpwhereid=1