title: Show the declared variable value while executing stored procedure
body: <p>I have stored procedure like this:</p>
  
  <pre><code>alter procedure [dbo].[testdate]
  as  
  begin    
     declare @current nvarchar(100),     
             @date1 datetime    
  
     select @current = getdate()    
     select @date1 = getdate()  
  end
  </code></pre>
  
  <p>While executing I want to show the values of <code>@current</code> and <code>@date1</code>..</p>
  
  <p>How can I declare these two variables?</p>
  
  <p>Now I am getting 0</p>