Untitled

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