Getting values of element which is going to be deleted? 1

[edita]

Hello,
I'm writing trigger INSTEAD OF DELETE and I want to get values of element which is going to be deleted. How can I retrieve it?

Thanks for help

 

[swampBoogie]

In the trigger there is a table named deleted which contains the rows affected by the query causing the trigger to be executed.

e.g.

create trigger ...

...
if exists (select * from deleted where ipk = 4711)
begin
-- do something
end
else
begin
-- do somewhat
end

 

[edita]

The problem is that I know nothing about any values of this element, so I cannot write condition WHERE... and this element isn't deleted yet. The situation is: user wants to delete an element, but it cannot be done ad hoc, so I need a trigger, which do sth with elements referencing to this one and then delete it.
I hope that now I described it more precisely and I'm still waiting for your help

 

[edita]

Thanks SwampBoogie
Your advice was very helpful, I just needed to change form a little, so my second question is not actual.