The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

Status: Accepting Votes Submitted by on ‎09-05-2019 04:00 PM
2 Comments (2 New)

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
‎08-31-2022 05:13 PM
Status changed to: Accepting Votes
 
0 Likes
simonaubert_bd
13 - Pulsar
‎02-03-2023 03:49 AM

Hello @aweiss2k and @AlteryxCommunityTeam  This is a duplicate of this idea :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Pre-SQL-for-InDB/idi-p/94203

 

0 Likes
Labels