title: How to see the result of the execution of the procedure without updating data tables?
body: <p>I have stored procedure with <code>$UPDATE</code> inside it. I want to see the result of executing this procedure without doing changes in my tables. </p>
  
  <p>I'm thinking about PRINT and RAISERROR, but I didn't find out how to do it properly - Do I need to modify my procedure, or I can specifically execute my procedure.</p>
  
  <p>Some of my procedure code: </p>
  
  <pre><code>...
  UPDATE Table SET DateChange = @DateCh
  </code></pre>
  
  <p>Procedure executing</p>
  
  <pre><code>GO
  DECLARE @UF int
  EXECUTE @UF = [dbo].[sp_GoProc] 
  GO
  </code></pre>
  
  <p>In the output, I expect to see the updated values in the tables or part of the table that was updated.</p>