DECLARE @T Table (ID int, Name varchar(50), ParentId INT);

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

DECLARE @T Table (ID int, Name varchar(50), ParentId INT);

INSERT INTO @t VALUES
(1  ,'Home',                    0),
(2  ,'Products',                0),
(3  ,'SubProduct1',         2),
(4  ,'SubProduct2',         2), 
(5  ,'Subsub',           4),
(6  ,'ii. ......',          4),
(7  ,'About',                   0);

SELECT * FROM @t;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results