title: SQL update trigger
body: <p>I want a SQL trigger to fire when a table is updated. I have a table called SimActivation and a stored procedure called spUpdateMnpDate that takes two parameters, msisdn(varchar) and date(datetime).</p>
  
  <p>When the SimActivation table is updated I want to call the procedure with the new values. </p>
  
  <p>Here is what I got at the moment, after changing it back and forth:</p>
  
  <pre><code>USE StoreSale;
  GO
  CREATE TRIGGER dbo.tSyncMnpDate
  ON [dbo].[SimActivation]
  AFTER UPDATE
  AS      
      DECLARE @date datetime
      DECLARE @msisdn varchar(10)
      SET @date = (select ProcessDate from inserted)
      SET @msisdn = (select Msisdn from inserted)
      EXEC [spUpdateMnpDate] 
      @msisdn, @date;
  
  GO
  </code></pre>
  
  <p>Can anyone point me in the right direction? </p>
  
  <p>Thanks :)</p>