title: Not showing all records in After Insert trigger in SQL Server
body: <p>I have a table <code>table1</code> with some data:</p>
  
  <pre><code>create table table1
  (
       c1 varchar(20),
       c2 varchar(20)
  )
  
  insert into table1 values('1','A')
  insert into table1 values('2','B')
  insert into table1 values('3','C')
  insert into table1 values('4','D')
  insert into table1 values('5','E')
  insert into table1 values('6','F')
  </code></pre>
  
  <p>Now I created another table with the same structure called <code>table2</code> :</p>
  
  <pre><code>create table table2
  (
      c1 varchar(20),
      c2 varchar(20)
  )
  </code></pre>
  
  <p>Then I created an <code>After Insert</code> trigger on <code>table2</code> :</p>
  
  <pre><code>CREATE TRIGGER trgAfterInsert 
  ON [dbo].[table2] 
  FOR INSERT
  AS
      declare @c1 varchar(20);
      declare @c2 varchar(20);
      declare @audit_action varchar(100);
  
      select @c1 = i.c1 from inserted i;  
      select @c2 = i.c2 from inserted i;  
  
      set @audit_action = 'Inserted Record -- After Insert Trigger.';
  
      insert into table2_Audit(c1, c2, Audit_Action, Audit_Timestamp) 
      values(@c1, @c2, @audit_action, getdate());
  
      PRINT 'AFTER INSERT trigger fired.'
      GO
  </code></pre>
  
  <p>There is a problem that when i copy all data of <code>table1</code> to <code>tabe2</code> then in Audit table only one record show.It not show all inserted record.</p>
  
  <p>I use this query for copy the record in <code>table2</code>:-</p>
  
  <pre><code>  insert into table2(c1,c2) select c1,c2 from table1
  </code></pre>