Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

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
Top Solution Authors