title: Is it possible to pass values to a table type parameter from PYODBC to SQL Server?
body: <p>I created a test type as a table with the below columns:</p>
  
  <pre><code>CREATE TYPE [dbo].[TestType] AS TABLE
                                  (
                                      [TestField] [varchar](10) NULL,
                                      [TestField2] [int] NULL
                                  )
  </code></pre>
  
  <p>I then created a stored procedure the takes that table type as a parameter.</p>
  
  <pre><code>CREATE PROCEDURE TestTypeProcedure (@tt TestType READONLY)
  AS
      SELECT *
      FROM @tt;
  </code></pre>
  
  <p>My goal is to be able to pass something like a list of lists as the parameter for the table type. Is that even possible?</p>
  
  <pre><code>myList = [['Hello!', 1], ['Goodbye!', 2]]
  ....
  cursor.execute('{{Call {TestTypeProcedure} ({?})}}', myList)
  </code></pre>