How can we run a query that has Transact-SQL syntax

Question

I am trying to find a way to run a MS SQL server query that has Transact-SQL syntax (Use, Go). Can Alteryx handle this type of query?

Example:

Use NCI Go
SELECT
[customer] as customer
,[address] as address
FROM [NCI].[database].[table]

danilang · Accepted Answer

Hi @ascanlan

You should be able to remove the GO statements if you end each line with a semi colon.

Use NCI;
SELECT
[customer] as customer
,[address] as address
FROM [NCI].[database].[table];

In your case though, you don't need the Use NCI directive, since you have [NCI] in the fully qualified table name; [NCI].[database].[table]

Dan