community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

SQL - What you can and cannot do

Asteroid

Alteryx Community, it's finally Thursday.........

 

In Alteryx server, I am trying to use a query from SSMS.  The first line of code in the query is 

 

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

 

Right away, the query has failed.  Which leads me to ask the question.  What can or cannot be done in Alteryx using SQL - specifically the SSMS flavor?

 

Can you, for example, create temporary tables?  Are there any other situations I should be aware of?  Thanks!!

Asteroid

Thanks for the reply @surendar.  

Labels