title: Call stored proc from after insert trigger
body: <p>Perhaps a stupid question!</p>
  
  <p>If I call a stored proc from an After Insert trigger (T-SQL) - then how do I get the values of the "just inserted" data?
  e.g.</p>
  
  <pre><code>   CREATE TRIGGER dbo.MyTrigger
      ON  dbo.MyTable 
       AFTER INSERT
      AS 
       BEGIN
  
         EXEC createAuditSproc 'I NEED VALUES HERE!' 
  </code></pre>
  
  <p>I don't have any identity columns to worry about - I just want to use some of the "just inserted" values to pass into my sproc.</p>
  
  <p>Edit: For clarification - I need this to call a sproc and not do a direct insert to the table, since the sproc does more than one thing.  I'm working with some legacy tables I can't currently amend to do things 'properly' (time/resource/legacy code), so I have to work with what I have :(</p>