You can translate the question and the replies:

Error: Received exception with message 'Incorrect syntax near the keyword 'into'

Select * into #Temp from xyz Select * from #Temp When I run this Script using Create Base view from Query, I am getting the below error message. Error: Received exception with message 'Incorrect syntax near the keyword 'into' MS SQL Server 2014 JDBC connection WITH clause takes more time and hence we rely on 'INTO #' option
user
23-10-2019 15:11:24 -0400

1 Answer

Hi, [Temporary tables](https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-temporary) in Microsoft SQL Server will exist at the *session level*. (i.e.,) they are only visible to the session in which they were created and are automatically dropped when that session logs off. Hence, in Denodo you will be able to introspect the temporary tables created in SQL Server but it is not persistent and cannot be shared with other sessions. Each session that defines a temporary table of the same name has its own unique description of the temporary table. When the session terminates, the rows of the table are deleted, and the description of the temporary table is dropped. So, for databases like SQL Server, you will be able to [introspect and create](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-a-jdbc-data-source) global temporary tables(table prefixed with ##), normal tables, etc in Denodo as required apart from the Temporary tables which are created by prefixing the table name with a #. Hope this helps!
Denodo Team
24-10-2019 07:34:00 -0400
You must sign in to add an answer. If you do not have an account, you can register here