title: Suppress result sets from trigger
body: <p>I have a sql statement that first updates, then selects:</p>
  
  <pre><code>  UPDATE myTable 
    SET field1=@someValue
    WHERE field2=@someValue2
  
    SELECT 1 returnValue 
  </code></pre>
  
  <p>The process that consumes the reults of this statement is expecting a single result set, simple enough.</p>
  
  <p>The problem arises because an update trigger was added to the table that produces a result set, i.e. it selects like so:</p>
  
  <pre><code> SELECT t_field1, t_field2, t_field3 FROM t_table
  </code></pre>
  
  <p>The obvious solution is to split up the statments.  Unfortunatley, the real world implementation of this is complex and to be avoided if possible.  The trigger is also nessecary and cannot be disabled. </p>
  
  <p>Is there a way to supress the results from the update, returning only the value from the select statement? </p>