Get updated column value and old value ON Update ,insert Trigger
<p>I m new to Triggers. I have table 'Sample' and 'SampleAudit'. I created Trigger 
For Update and Insert. The trigger is as follows.</p>

<pre><code>CREATE TRIGGER [ss].[SampleTrigger]
   ON  [ss].[Sample] 
   FOR INSERT,UPDATE

AS 
    declare @fullname varchar(200);
    declare @addressline1 varchar(200);
    declare @addressline2 varchar(200);
    declare @landmark varchar(200);
    declare @city bigint;
    declare @state bigint;
    declare @pin varchar(50);
    declare @country varchar(100);
    declare @auditaction varchar(100);


    select @fullname=i.fullname from inserted i;
    select @addressline1=i.addressline1 from inserted i;
    select @addressline2=i.addressline2 from inserted i;
    select @landmark=i.landmark from inserted i;
    select @city=i.city from inserted i;
    select @state=i.state from inserted i;
    select @pin=i.pin from inserted i;
    select @country=i.country from inserted i;

   if UPDATE(@fullname)
    set @auditaction= 'updated FullName from'+oldval+' to '+ new value ;

    if UPDATE(@addressline1)
    set @auditaction= 'updated addressline1 from'+oldval+' to '+ new value ;

    if UPDATE(@addressline2)
    set @auditaction= 'updated addressline2 from'+oldval+' to '+ new value ;

    if UPDATE(@landmark)
    set @auditaction= 'updated landmark from'+oldval+' to '+ new value ;



insert into [ss].[SampleAudit]
(FullName,AddressLine1,AddressLine2,LandMark,City,State,Pin,Country,auditaction)
values(@fullname,@addressline1,@addressline2,@landmark,@city,@state,@pin,@country,@auditaction)
</code></pre>

<p>Here each time updating a new raw is inserting to Audit table. So </p>

<pre><code>    if Update(fullname)
    if UPDATE(@addressline1)  
    if UPDATE(@addressline2)  
    if UPDATE(@landmark)
</code></pre>

<p>all are updating. So how can i get which and all fields are updated ? and old and new value for all updated fields.</p>

<pre><code>1. I need to track which and all fields updated.
2. and from which value to which value it is updated ?
</code></pre>