Use SQL to obtain the file path on the server without using ASP scripts

Declare @ path nvarchar (260)
Set @ Path = 'f :\'

If right (@ path, 1) <> '\'
Set @ Path = @ path + '\'
If object_id ('tempdb .. # ') is not null
Drop table #
Create Table #(
Id int identity,
Directory nvarchar (260 ),
Depth int,
Isfile bit)
Insert # exec master. DBO. xp_dirtree
@ Path = @ path,
@ Depth = 0,
@ File = 1

Declare @ depth int, @ depthmax int
Update # Set
Directory = @ path + directory
Where depth = 1
Select
@ Depth = 2,
@ Depthmax = max (depth)
From #
While @ depth <= @ depthmax
Begin
Update a set
Directory = (
Select top 1
Directory
From #
Where depth = @ depth-1
And isfile = 0
And id <A. ID
Order by ID DESC
) + N' \ '+ directory
From #
Where depth = @ depth
Set @ depth = @ depth + 1
End
Select * from #