Hvordan bruge trigger?

Nu har jeg ikke anvendt triggers særligt meget.... men vil dit ovenstående eksempel ikke være bedre tjent med at være en stored procedure. F.eks_

CREATE PROCEDURE test

@DenVariabelDuSenderMedNårDuKalderDinSP Int --Int = datatype

Delete from tblTimer Where pnr = DenVariabelDuSenderMedNårDuKalderDinSP

Go

Is there a relationship between tblavn and tblTimer, for example, does the field pnr exist in tblNavn and also tblTimer?
Normally you would carry out tasks in a trigger which are related to the table/record which the trigger is activated on.
When you delete a record then you have access to the deleted records data in the trigger in a table named deleted. Example:

DECLARE
@tblNavnpnr int
SELECT
@tblNavnpnr = pnr
FROM deleted

Then you could delete from tblTimer

DELETE FROM tblTimer WHERE pnr=@tblNavnpnr

or something like that...

texas2>Theres gone quite som etime since this question was placed, how about taking a look!

tak :o)