title: Trigger not firing for all rows when inserting multiple rows SQL
body: <p>Am facing a problem with trigger.</p>
  
  <p>I created a trigger for a table like this</p>
  
  <pre><code> ALTER TRIGGER [dbo].[manageAttributes] 
  ON [dbo].[tr_levels]
  AFTER insert
  AS 
  BEGIN
  
  set nocount on
  declare @levelid int
  
  select @levelid=levelid  from inserted
  insert into testtable(testid) values(@levelid)
  -- Insert statements for trigger here
  
  END
  </code></pre>
  
  <p>But when I insert rows into table tr_levels like this</p>
  
  <pre><code>insert int tr_levels (column1,colum2) values(1,2)
  </code></pre>
  
  <p>trigger triggered perfectly</p>
  
  <p>But when I tried to insert into table as a bulk like this</p>
  
  <pre><code>insert int tr_levels (column1,colum2) values(1,2),(3,4),(5,6)..
  </code></pre>
  
  <p>Trigger doesnt fires for all the rows. It fires only one time for the first row. Is that bug with SQL or is there a solution to trigger the trigger for all rows insertion in a bulk insert query</p>