Slette relaterede records på SQL7

NO it isnt available in SQL Server 7.0
You could do this with a TRIGGER

EXAMPLE:
CREATE TRIGGER [trDeleteDetail] ON [tblOrder]
FOR DELETE AS

DECLARE
@OrderID int

SELECT
@OrderID = OrderID

FROM deleted

/*Delete Detail*/
Delete FROM tblDetail WHERE OrderID = @OrderID

copeland>Hows it going with this question?

Jeg er ikke helt sikker på hvordan man laver TRIGGER, hvis jeg nu for forståelsens skyld har to små tabeller:

TABEL1
KatID
KatName

TABEL2
SubID
KatID
SubName

De rellaterer så på KatID, når jeg sletter en post i TABEL1 skal alle posteri TABEL2 med samme KatID slettes, men hvor og hvordan skriver jeg dette i SQL7.....?


mvh
Anne

You can create a trigger by right clicking on the table (TABEL1) and choose ALL TASKS then MANAGE TRIGGERS. Then in the window enter this:

CREATE TRIGGER [trDeleteDetail] ON [TABEL1]
FOR DELETE AS

DECLARE
@KatID int

SELECT
@KatID = KatID

FROM deleted

Delete FROM TABEL2 WHERE KatID = @KatID

An explanation!
This is a delete trigger which gets triggered (started) when you delete a record from TABEL1
In the trigger you have access to the DELETED record where you select the KatID which is used to delete all the records from TABEL2 which have a KatID = KatID from TABEL1

Hope you understand now!

Anne! Hows it going?

Are we getting there?

You can also run the SQL in query analyzer!

Undskyld ventetiden...

Jeg vil lige teste det nu og så vender jeg tilbage.


Anne

Anne>Have you got it to work yet?

>>terry

Undskyld den lange svartid.....det virker perfekt som det skal 1000 tak


Anne

great to hear, og selv tak :o)