SQL: Declare variables in Database Table Connector node

KNIME Analytics Platform
1

Hello,

apparently it is not possible to declare variables in a Database Table Connector node with SQL code like 

DECLARE @Var1 INT
DECLARE @Var2 INT
SET @Var1 = 1
SET @Var2 = 2
SELECT @Var1 'Var1', @Var2 'Var2'
GO

I am getting the error "Execute failed: Incorrect syntax near the keyword 'DECLARE'.".

I am using KNIME 3.5 on Windows 7 and the database I am connecting to is MS SQL Server 2014.

Any chance that variable declarations in SQL will be supported in the future?

Thank you and kind regards
Florian

2

AFAIR, you should end the second DECLARE statement with a semi-colon (;). The same applies to the second SET statement and, I think, the same would apply to the SELECT statement, thus rendering the GO command useless.

3

Thanks for that hint. I tried all kinds of combinations I found in Microsoft documentations but unfortunately I could not get it running.

I heard KNIME will update the SQL nodes in one of the next releases, so maybe it will be supported in the future. Not a big deal for us now but would be nice to have.