Luc,

There's no current record in a trigger. A trigger is fired once per SQL statement regardless how many records are affected by such statement. The info about affected records is presented in a trigger in two special tables: DELETED and INSERTED. Keep also in mind, that triggers could fire recursively if DB setting allow it.

>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>>              && Current Value
>
>UPDATE Table SET Somefield = SomeValue WHERE Table.ID_Field <> @ID_CurrentRecord
>