search

denisenkom / pytds

Python DBAPI driver for MSSQL using pure Python TDS (Tabular Data Stream) protocol implementation
MIT License
192 stars 53 forks source link

Local temporary tables are inaccessibly when passing named parameters #70

Closed dnp1 closed 6 years ago

dnp1 commented 7 years ago

https://github.com/denisenkom/go-mssqldb/issues/249 The same error present in issue above, in go driver, is present here.

denisenkom commented 6 years ago

That is expected behavior since driver uses sp_executesql. I think you would have same results on Microsoft's SQL driver.

https://stackoverflow.com/questions/8040105/execute-sp-executesql-for-select-into-table-but-cant-select-out-temp-table-d