SQL紀錄下資料更新者UserID

CREATE TRIGGER trTable1_UPD
ON Table1
AFTER UPDATE, DELETE
AS
BEGIN
    --被刪除或是被更新的資料
    SELECT *, SUSER_SNAME() AS loginUser, HOST_NAME() AS hostName FROM deleted;
    --更新後的資料
    SELECT *, SUSER_SNAME() AS loginUser, HOST_NAME() AS hostName FROM inserted;
END
GO