title: prevent SQL Server sproc from returning result set if select statement errors
body: <p>if i have a stored procedure that handles errors in a catch statement is there a way to prevent an empty result set from returning if the select statement errors?</p>
  
  <pre><code>BEGIN TRY
  
  select 1/0 as WHAT;
  
  END TRY
  BEGIN CATCH
  
  SELECT 0 AS status_code;
  
  END CATCH
  </code></pre>
  
  <p>looking to get back 1 result set regardless if it errors or if is succeeds (obviously this example will always error)</p>