USE ProofOfConcept;
GO
IF OBJECT_ID(N'dbo.MyTable001') IS NOT NULL 
    DROP TABLE dbo.MyTable001;
IF OBJECT_ID(N'dbo.AuditLog') IS NOT NULL 
    DROP TABLE dbo.AuditLog;
GO
CREATE TABLE dbo.MyTable001
    (ID INT IDENTITY
            PRIMARY KEY,
     Col1 VARCHAR(100),
     Col2 VARCHAR(100));
GO
CREATE TABLE dbo.AuditLog
    (ID INT IDENTITY
            PRIMARY KEY,
     LogTime DATETIME NOT NULL
                      DEFAULT (GETDATE()),
     LogEntry XML);
GO
CREATE TRIGGER dbo.MyTable001_Audit ON dbo.MyTable001
    FOR UPDATE, DELETE
AS
    SET NOCOUNT ON;

    INSERT  INTO dbo.AuditLog
            (LogEntry)
            SELECT  (SELECT 'dbo.MyTable001' AS Obj,
                            *
                     FROM   DELETED
                    FOR
                     XML RAW('PriorValues'),
                         TYPE);
GO
INSERT  INTO dbo.MyTable001
        (Col1, Col2)
VALUES  ('A', 'B'),
        ('C', 'D');
GO
SELECT  *
FROM    dbo.AuditLog;
GO
UPDATE  dbo.MyTable001
SET     Col2 = 'E'
WHERE   ID = 2;
GO
SELECT  *
FROM    dbo.AuditLog;
GO

NullIf(deleted.MyCol1, inserted.MyCol1) as Col1, NullIf(deleted.MyCol2, inserted.MyCol2) 
FROM inserted
FULL OUTER JOIN deleted
  ON inserted.ID = deleted.ID