Loading
Salesforce から送信されるメールは、承認済ドメインからのみとなります続きを読む

Error "Incorrect syntax near the keyword 'DECLARE'" When Using DECLARE in Custom SQL

公開日: Feb 24, 2026
説明

When using a DECLARE statement to declare a variable in Custom SQL with a SQL Server data source, the following error occurs:
 

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'DECLARE'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ')'.

 

Cause

Tableau Desktop wraps Custom SQL queries in a SELECT statement before sending them to the database.

 

解決策

Run the DECLARE statement in an initial SQL command.

その他のリソース

You can find an example of using initial SQL to run a DECLARE statement in the following blog post: Actually you can use variables, CTEs and other fancy SQL with Tableau after all.

Note: The above blog post is hosted on a third-party website. Please note that while we make every effort to keep references to third-party content accurate and up to date, the information we provide here might change without notice.

 

ナレッジ記事番号

001471583

 
読み込み中
Salesforce Help | Article