Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

After upgrading to Windows 22H2 SQL queries stopped working

Hi,

After my laptop was upgraded to Windows 22H2 a query below that worked before stopped working with error message "Incorrect syntax near keyword Declare:\42000=156."

 
DECLARE @UserId int = 54;
SELECT * FROM [dbo].[TableFn](@UserId) 

Please help,

Thank you

2 REPLIES 2

An update.

We have discovered that Alteryx inserts "Select * from" as a first statement.

If we change our query to : 

 EMPTY_TABLE;
DECLARE @UserId int = 54;
SELECT * FROM [dbo].[TableFn](@UserId) 

it works.


Alteryx changes our custom script to

 SELECT * FROM EMPTY_TABLE;
DECLARE @UserId int = 54;
SELECT * FROM [dbo].[TableFn](@UserId) 


  
The question remains why this behavior was changed after upgrading Windows.

KSassone
8 - Asteroid

I found the same issue with my .sql scripts I use in an Input tool that worked prior to an Alteryx upgrade, but now the Test Query Error logs shows that "SELECT * FROM" has been inserted into my script. Is there a way to remove the automated "SELECT * FROM" into my script?

 

 

Labels