Home Forums SQL Server 7,2000 T-SQL Trigger to update field in a new record RE: Trigger to update field in a new record
Scott Coleman
One Orange Chip
Points: 27451
More actions
August 13, 2004 at 7:35 am
#518858
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