title: How to update foreign key referenced table using trigger, in SQL Server?
body: <p>Say I have these tables:</p>
  
  <pre><code>CREATE TABLE person 
  (
      person_id INT NOT NULL PRIMARY KEY,
      name VARCHAR NOT NULL,
      phone INT,
  );
  
  CREATE TABLE volunteers 
  (
      person_id INT NOT NULL PRIMARY KEY,
      skill VARCHAR,
      FOREIGN KEY (person_id) REFERENCES person(person_id)
          ON DELETE CASCADE
          ON UPDATE CASCADE
  );
  </code></pre>
  
  <p>Could I create a trigger on <code>volunteers</code> that could insert into <code>person</code> table when I insert a new record in <code>volunteers</code> table. </p>
  
  <p>Like this:</p>
  
  <pre><code>INSERT INTO volunteers (person_id, name, skill) 
  VALUES (12345, 'abc xyz', 'cooking');
  </code></pre>
  
  <p>If not using trigger, is there any alternatives?</p>