Watch out for multi-row operations in triggers.

CREATE TRIGGER trNumber

ON tbl

FOR INSERT, UPDATE

AS

UPDATE t SET Number = i.ID

FROM tbl t

INNER JOIN inserted i ON t.pk = i.pk

WHERE i.Number IS NULL