title: How do you specify 'DEFAULT' as a SQL parameter value in ADO.NET?
body: <p>I have a parameterized SQL query targetted for SQL2005 which is dynamically created in code, so I used the ADO.NET <code>SqlParameter</code> class to add sql parameters to <code>SqlCommand</code>.</p>
  
  <p>In the aforementioned SQL I select from a Table Valued Function with has defaults. I want my dynamic sql to sometimes specify a value for these default parameters, and other times I want to specify that the SQL <code>DEFAULT</code> - as defined in the Table Valued Function - should be used.</p>
  
  <p>To keep the code <em>clean</em> I didn't want to dynamically add the SQL <code>DEFAULT</code> keyword and parameterize it when a non-default is to be used, I just wanted to set <code>DEFAULT</code> as the value of my <code>SQLParameter</code>.</p>
  
  <p>Can I? What is best practice in such an instance?</p>