After upgrading to Windows 22H2 SQL queries stopped working

Question

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

KSassone · Answer

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?

MichaelVitenzonAlt · Answer

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.