title: Syntax error with parameterized queries after switching from pyodbc to pymssql
body: <p>I have <strong>13-15MB</strong> raw files to load its data into DB, and it takes around <strong>50-55mins</strong> to insert around <strong>30k-35k</strong> rows using executemany with pyodbc and it worked fine but its processing time is high.</p>
  
  <p>For testing the performance I tried pymssql but it is showing syntax error here </p>
  
  <pre><code>x = [('a',1),('b',2).... ]  # inserting only 999 rows at a time
  qry = "INSERT INTO ["+tablename+"] VALUES({}) ".format(placeholders)
  cursor.executemany(qry,x)
  
  print qry
   # INSERT INTO [my_T] VALUES(?,?,?,?,?,?,?,?,?,?,?,?...) 
  </code></pre>
  
  <p>AT executemany() it is thowing error as  </p>
  
  <p>Error:</p>
  
  <blockquote>
    <p>Error in loadData (102, "Incorrect syntax near '?'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n"</p>
  </blockquote>