[ODBC - MS SQL] temp tables

SOCI / soci

Official repository of the SOCI - The C++ Database Access Library

http://soci.sourceforge.net/

Boost Software License 1.0

1.42k stars 478 forks source link

[ODBC - MS SQL] temp tables #1045

Open xakod opened 1 year ago

xakod commented 1 year ago

Hello! Does soci support temp tables between statements? Looks like it internally uses SQLPrepare. If we create temp table with SQLPrepare temp table will be deleted after execute (statement lifetime).

MS mention this in docs https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-queries/executing-statements/prepared-execution?view=sql-server-ver16 Prepared statements cannot be used to create temporary objects on SQL Server.

vadz commented 1 year ago

Sorry, no idea, but from the link you give it indeed looks like it doesn't. Please don't hesitate to update this issue if you find a way to make this work.