title: How to create a fetch primary key of the updated table on which we create a trigger?
body: <p>I have a Product table and a ProductPriceLog table to maintain price of a product.
  Assume product table has 3 fields <code>[ProductId, ProductName, ProductPrice]</code> and price history just has 2 fields <code>[ProductId(fk), productprice]</code></p>
  
  <p>I am attempting to write a trigger which would add a log entry each time we update the price of the product.</p>
  
  <pre><code>CREATE TRIGGER price_change_trg
  ON PRODUCT
  AFTER INSERT OR UPDATE OF ProductPrice ON PRODUCT
  BEGIN
  
       INSERT INTO ProductPriceLog ( @idd , ProductPrice)
  END;
  </code></pre>
  
  <p>Specifically, how to I fetch the productId from the Product table's row which was updated? </p>