Our Training Programs

All contents are copyright of their authors.

Recursive function with Sql Data Base

Recursive function with Sql Data Base

Y G

9yAsked Nov 4, 2016, 12:28 AM1.1kVisual Basic .NET

Can anyone help me in solving this :

USING RECURSIVE FUNCTION:

SQL DATABASE

TABLE

COLUMN1(id) Column2(Name) Column3(parentId)

1 a Null

2 b 1

3 c 1

4 d 2

5 e 3

in view there is a text box it allows name and id

1. When I enter 1 it has to display the id i.e 1 name a and parentId i.e Null along with the child information i.e 2,b, and 3,c

2. When I enter 3 or c it has to display the parent info i.e 3,c,1 and the child info i.e. 5,e,3 ................

using Recursive function

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Nitin Sontakke9y ago
You can achieve this with the help of CTE i.e. Common Table Expression (depending on which version of SQL Server you are using) and joining it to itself. In first part of the query you can send the key value.

Please google CTE and recursive query to know better.