Untitled
unknown
sqlserver
10 months ago
295 B
8
Indexable
CREATE TRIGGER [dbo].[DmN_Last_Ml_Time] ON [dbo].[Character] AFTER UPDATE AS BEGIN DECLARE @Name varchar(50) SET NOCOUNT ON; IF (UPDATE(mLevel)) BEGIN SELECT @Name = Name FROM inserted BEGIN UPDATE Character SET lastMLTime = GETDATE() WHERE Name = @Name END END END
Editor is loading...
Leave a Comment