Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Self Referencing DELETE Query Deletes All Rows
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00934181
Message ID:
01417748
Vues:
38
>Naomi,
>
>>Sorry, it's an old thread, but you should have used INNER JOIN for your delete statement and then it would have worked. I'm wondering if there is any valid reason to ever use LEFT JOIN while doing a DELETE.
>
>As a way around not having TRUNCATE rights? *wg*

:))))))))
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform