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
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.
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?