title: Get default value of stored procedure parameter
body: <p>I have created below stored procedure with default value:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[Sample1] 
       @OrderID INT = 10285
  AS
      SELECT ProductName, OrderID
      FROM Products P, [Order Details] Od
      WHERE Od.ProductID = P.ProductID 
        AND Od.OrderID = @OrderID
  </code></pre>
  
  <p>Tried to get default value (10285) of parameters using <code>sys.parameters</code>.</p>
  
  <pre><code>Select a.object_id, a.default_value
  from sys.parameters a
  inner join sys.types b on b.system_type_id = a.system_type_id
  where Object_id = object_id('[dbo].[Sample1]')
  </code></pre>
  
  <p>But I got NULL as <code>default_value</code>, while I was expecting <code>10285</code> as <code>default_value</code>.</p>
  
  <p>Is there any way to get default value?</p>