title: How to use SQL Server Management studio - "Execute Stored Procedure" for User Defined Table Types?
body: <p>I am trying to right click a stored procedure in <em>SQL Server Management Studio 2012</em> and trying to execute a stored procedure which accepts a single parameter of type <code>tblType_XXX</code> which is a <a href="http://msdn.microsoft.com/en-us/library/bb522526%28v=sql.105%29.aspx">User Defined Table Type</a>. But when I try to pass a single value I get this error</p>
  
  <pre><code>Msg 206, Level 16, State 2, Procedure uspGetXXXXXXXX, Line 0
  Operand type clash: int is incompatible with tblType_XXX
  </code></pre>
  
  <p>How can I specify a parameter of type <code>tblType_XXX</code> in the <em>SQL Server Management Studio</em> -> <em>Execute Stored Procedure</em> from the UI?</p>
  
  <p><code>tblType_XXX</code> only contains one column of type <code>int</code></p>