Syntax error when inserting multiple rows using Microsoft SQL node with Azure Dedicated SQL pool

[Cathryn17]

Describe the problem/error/question

When inserting multiple rows (items) into an Azure Dedicated SQL pool (on a regular Azure SQL Server), we receive a syntax error from the DB (“Parse error at line: 1, column: 73: Incorrect syntax near ‘,’“). Using the exact same node but with Credentials pointing to a different DB (a regular SQL database) on the same server works without issue. Inserting a single row also works on the Dedicated SQL pool. But when we try to insert more than on row, the syntax error occurs.

What is the error message (if any)?

Parse error at line: 1, column: 73: Incorrect syntax near ‘,’

Please share your workflow

Share the output returned by the last node

Parse error at line: 1, column: 79: Incorrect syntax near ‘,’.

Information on your n8n setup

• n8n version: 1.108.2
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): default
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Debian 5.10.237-1 (2025-05-19) x86_64

[Zelite]

Hey @Cathryn17 welcome to the community.

Regarding your questions The problem is that Dedicated SQL Pools don’t support the same multi-row INSERT syntax that regular SQL Server does.

[Cathryn17]

Thanks for your input, @Zelite! I wasn’t aware of the different syntax in Dedicated SQL Pools für multi-row inserts. That’s unfortunate. Do you think a feature request for this makes sense and has a realistic chance of being accepted?

[Zelite]

Yes @Cathryn17 submit a feature request, I feel this is exactly the kind of improvement the n8n team would welcome.

And if you found the answers above helpful kindly mark as the solution.

[Cathryn17]

Thanks, @Zelite , I created a new feature request here: Add support for inserting multiple rows in Azure Dedicated SQL Pool and marked your reply as the solution.

[Zelite]

Good good mate thanks