search

zillow / ctds

Python DB-API 2.0 library for MS SQL Server
MIT License
83 stars 12 forks source link

Support for table variables #88

Open juls858 opened 3 years ago

juls858 commented 3 years ago

Is there planned support for table variables? This would enable use cases such as stored procedures that require table valued parameters.

joshuahlang commented 3 years ago

Unfortunately that requires support in FreeTDS itself which isn't currently available, per https://github.com/FreeTDS/freetds/issues/279 Should FreeTDS ever add support, I don't think it would be a huge effort to support it in ctds

I'd recommend python-tds if you need TVP support. Last I looked the code was very clean and the library itself functioned very well for me in the past until the Python GIL became an issue when trying to increase thread counts