[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

DELETE records.

shapper

3/21/2007 6:18:00 PM

Hello,

I have 3 tables with their columns as follows:

+ LabelsInDocs [LabelId] PK FK , [DocsId] PK FK

+ Labels [LabelId] PK , [LabelName]

+ Docs [DocId] PK , [DocUrl]

I set Cascade Delete On so when I delete a Doc all records in
LabelsInDocs will be deleted.

However, when a Doc is deleted I want also to delete all records in
Labels for the labels which do not have any Doc associated to it in
LabelsInDocs.

How can I do this?

Thanks,
Miguel
1 Answer

RLoski

3/21/2007 6:50:00 PM

0

A trigger might work:

create trigger cascade_LabelsInDocs on LabelsInDocs for Delete
as
delete Labels from deleted d
where
Labels.LabelID = d.LabelID
and not exists (select 1 from LabelsInDocs ld where ld.LabelID = Labels
..LabelID)

--
Russel Loski, MCSD.Net