Triggers i 7.0

2 svar · 197 visningar · startad av ElMaco 28 juni 2001

ElMacoMedlem sedan juni 2000161 inlägg

Frågan28 juni 2001 17:26#1

Tjena... ...det e jag igen. :)

Jag har ju inge vidare kolla på vad motsvarande tabeller "deleted" och "inserted" heter i SQL 7.0

Vad skall ändras?

GO
CREATE TRIGGER TR_Companies_Profiles_Delete ON companies FOR DELETE
AS
BEGIN
		SET NOCOUNT ON
		
		DELETE FROM profiles WHERE profiles.companyID =(SELECT companyID FROM deleted.companyID)
END

Felet: "Server: Msg 208, Level 16, State 1, Procedure TR_Companies_Profiles_Delete, Line 6
Invalid object name 'deleted.companyID'."

------------------
To understand recursion, we must first understand recursion.

LarsGMedlem sedan dec. 200012 464 inlägg

28 juni 2001 17:30#2

CREATE TRIGGER TR_Companies_Profiles_Delete ON companies FOR DELETE
AS
BEGIN
SET NOCOUNT ON

DELETE FROM profiles WHERE profiles.companyID in(SELECT companyID FROM deleted)
END

------------------
essentitia preter non sans multiplicandum

ElMacoMedlem sedan juni 2000161 inlägg

28 juni 2001 17:35#3

Tusen tack.

...dags för kaffe.

*suck* :)

------------------
To understand recursion, we must first understand recursion.