Full Path Database Query

Question

Hello I am trying to solve this problem

Given a database table such as: create table file(id int, parentid int, name varchar(1024), size int, type char(1)); write a single (recursive) database query to list FULL PATH of all files. [assume type is either "F" or "D" for file or directory]. Your query should give you similar output to unix command: "find . -type f".

This is what I've got so far but I dont know if its right

 Create FUNCTION GetFileName
    (
     @fullpath nvarchar(260)
    ) 
    RETURNS nvarchar(260)
    AS
    BEGIN
    DECLARE @charIndexResult int
    SET @charIndexResult = CHARINDEX('\', REVERSE(@fullpath))

    IF @charIndexResult = 0
        RETURN NULL

I have tried doing that but I dont really know what i'm doing as I am stuck after that code

Gandalf · Accepted Answer · 2015-12-21 21:40:21Z

1

You'll need to use non-standard SQL to create a recursive query, look into Common Table Expressions.

answered Dec 21, 2015 at 21:40

Gandalf

9,9178 gold badges58 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Full Path Database Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related