title: Pass explicit NULL value to stored procedure from T-SQL not from application
body: <p>At wits end with this
  How do I pass a null value to my stored procedure within SSMS?
  I have set two of my parameters to optional eg. </p>
  
  <pre><code> --This is inside my storedproc
   @name varchar(50)
   @surname varchar(50) = null,
   @text varchar(255) = null,
  </code></pre>
  
  <p>Now to execute</p>
  
  <pre><code> --Now execute without the 'text'
   EXEC sp_bla 'Noob Question Name', 'Noob Surname'
  </code></pre>