I am trying to create a trigger that will insert a record from a table into a another table whenever a record is updated.

CREATE TRIGGER [dbo].[trg_tblContent_backup_update] 
   ON [dbo].[tblContent]
   FOR UPDATE
AS 
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

     INSERT INTO tblContentUpdateBackup 
     (
        ContentID,
        revision,
        CountryID,
        QualificationID,
        ContentTitle,
        CourseID,
        ContentOrder,
        ContentStatus,
        ContentTypeID,
        Content,
        GenericPageID,
        GenericDisplay,
        altLanguage,
        locationID,
        languageID,
        defaultLanguage,
        courseGenericID,
        moduleID,
        ThemePageID,
        contentRelateID,
        alantestID,
        ContentBackup,
        LastModified,
        ProgrammeID,
        temp_contentRelateID
     
     )
     SELECT 
     
        ContentID,
        revision,
        CountryID,
        QualificationID,
        ContentTitle,
        CourseID,
        ContentOrder,
        ContentStatus,
        ContentTypeID,
        Content,
        GenericPageID,
        GenericDisplay,
        altLanguage,
        locationID,
        languageID,
        defaultLanguage,
        courseGenericID,
        moduleID,
        ThemePageID,
        contentRelateID,
        alantestID,
        ContentBackup,
        CURRENT_TIMESTAMP,
        ProgrammeID,
        temp_contentRelateID
     
     
     FROM INSERTED
    -- Insert statements for trigger here

END
GO

The trigger above that I have built inserts both the previous and updated records from tblContent into tblContentUpdateBackup, however I only want the previous record.

I'm nearly there, any help would be appreciated.

Thanks