title: Update query with parameters?
body: <p>I'm trying to create a trigger in MS SQL that overrides the update query ("instead of update"). I'd like to pass in an additional parameter to the trigger function, but so far, the only way I can do this is via the where clause or as part of the values I set. Is there another way of achieving this?</p>
  
  <p>I've seen similar things where functions are used to mimic a table which allows parameters to be passed to a select query (e.g. 'select * from table(42)'). It would be great if I could do a similar thing with the update query...</p>
  
  <p>Cheers,
  Max</p>