lundi 26 juin 2017

random tree by sql query or c#

I have a tree table in sql:

[Id]        INT          IDENTITY (1, 1) NOT NULL,
[Title]     VARCHAR (50) NOT NULL,
[ParentId]  INT          NULL,
[Level]    INT          NOT NULL.

I need to fill it with lots of random data rows. The depth of the tree must be at least 4. The tree must have arbitrary number of children. I need to make it with a help of console application or sql query.




Aucun commentaire:

Enregistrer un commentaire