Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

'Pre-SQL' Statements in Connect In-DB Tool

It would be great if the Connect In-DB tool supported 'Pre-SQL' statements like:

 

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

 

When I try and execute a query that runs fine in SSMS, like the below, I get an error in the Connect In-DB tool:

 

--

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

Select * From MyDatabase.MyTable

--

 

 

2 Comments
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
simonaubert_bd
13 - Pulsar