title: Is it possible to set current date in stored procedure parameter?
body: <p>I want to set GetDate() as default parameter value. But it shows error. Below is my block of code:</p>
  
  <pre><code>Create Proc XYS
  (
     @myDate datetime = GetDate()  //error
  
  )
  AS
  SET @myDate = GetDate() // i can do this but neither i want this nor I want to 
                             pass current date from front end or upper layer
  
  
  ....
  ....
  </code></pre>
  
  <p>As far as i know functions/dynamic values are not supported as this level, instead we are allowed hardcoded values. Any workaround?</p>