title: SQL Server triggers "For Each Row" equivalent
body: <p>I need to update multiple rows in a Parts table when a field in another table changes and I want to use a trigger. The reason for the trigger is many existing application use and modify the data and I don't have access to all of them. I know some databases support a For Each Row in the trigger statement but I don't think Microsoft does.</p>
  
  <p>Specificly I have two tables Parts and Categories.</p>
  
  <p>Parts has Part#, Category_ID, Part_Name and Original and lots of other stuff</p>
  
  <p>Category has Category_ID and Category_name.</p>
  
  <p>Original is a concatenation of Category_Name and Part_Name separated by a ':'</p>
  
  <p>For example Bracelets:BB129090</p>
  
  <p>If someone changes the Category_Name (for excample from Bracelets to Bracelets), the Original field must be updated in every row of the Parts table. While this is an infrequent event it happens enough to cause trouble.</p>
  
  <p>No Web and desktop applications uses Original</p>
  
  <p>All Accounting application use only Original</p>
  
  <p>It is my task to keep Accounting and the other application in sync.</p>
  
  <p>I did not design the database and the company that wrote the accounting program will not change it.</p>