You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

10 lines
271 B

/* test comment CREATE TRIGGER [test] */
-- Another comment
CREATE TRIGGER [dbo].[iutrgTriggerName] ON dbo.TableName
FOR INSERT, UPDATE
AS
UPDATE TableName
SET TableName.SomeColumn = 'something'
FROM inserted,TableName
WHERE inserted.TableNameId = TableName.TableNameId