6/7/2023 0 Comments Sql server cursor![]() ![]() By default, ODBC automatically opens a cursor for every result set returned from a SQL statement.Ĭursors are not supported on Azure Synapse. ![]() The SQL Server table involved the data set contains a ColumnStore Index. When running a workflow that contains queries connected to SQL Server or Azure Synapse (formerly known as Azure Data Warehouse), respectively the following error occurs:Įrror: Input Data (1): Error SQLExecute: Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.Įrror: Input Data (1): Error SQLExecute: Cursors are not supported on a table which has a clustered columnstore index.Statement(s) could not be prepared.
0 Comments
Leave a Reply. |