title: SQL Server - After Insert/ For Insert - Rollback
body: <p>I have the below trigger:</p>
  
  <pre><code>  CREATE Trigger instructor_expertise on CourseSections
       After Insert
       As Begin
       ......
  
       If (Not Exists(Select AreaName From AreasOfInstructor Where (InstructorNo = @InstructorNo AND AreaName = @AreaName))) 
       Begin 
       RAISERROR('Course not in instructors expertise', 16, 1)
       rollback transaction  
       End
       GO
  </code></pre>
  
  <p>My question is, does 'rollback transaction' remove the row?
  What if it's 'For Insert' instead, does 'rollback transaction' remove the row in that case?</p>
  
  <p>Thanks!!!</p>