Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Self Join Referential Integrity
Message
De
15/09/2011 13:27:22
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01523616
Message ID:
01523648
Vues:
27
>>>It does, but have you tested it?
>>>
>>
>>I am working on some data at the end of a huge import so don't want test it and find out it deletes all employees or something like that :)
>>
>>Now that you think it looks OK, I'll back up the database and do some tests.
>>
>>Thanks
>
>It seems to look OK, but I'm not 100% sure it's going to work as you may get into the same problem of nesting level exceeded.
>
>I suggest to create a test table (separate from your real life with the deep chain of parent/child and then try deleting a parent with many children, grand children, etc. and see, if it will work or not).

There's only one level deep, and my tests have worked so far.

Thanks
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform