I've been searching the BOL for a clue without sucess...
In a trigger,
how can I declare a variable for the current record?
I want a trigger to fire on an INSERT or an UPDATE.
DECLARE @ID_CurrentRecord Int
@ID_CurrentRecord= <<Table.ID_Field>>
UPDATE Table SET Somefield = SomeValue WHERE Table.ID_Field <> @ID_CurrentRecord
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)