title: Avoid returning result set from stored procedure
body: <p>Assume I have some stored procedure (and I can't change it) which is returning a result set:</p>
  
  <pre><code>create procedure test_procedure
  as
  begin
  
      select 1
  
  end
  </code></pre>
  
  <p>I know that I can insert result set into table, so it would be hidden to the calling code:</p>
  
  <pre><code>declare @t table(i int)
  
  insert into @t
  exec test_procedure
  </code></pre>
  
  <p>Are there any other ways to hide returning result set from the calling code? </p>
  
  <p><strong>Updated</strong></p>
  
  <p>It looks like I've been a bit confusing. I'm looking only for T-SQL answers (not .NET ones).</p>