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 …

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.

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?

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.

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

Questions

Cathryn17 September 1, 2025, 7:48am 5

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.

Topic		Replies	Views
Add support for inserting multiple rows in Azure Dedicated SQL Pool Feature Requests microsoft-sql , mssql	0	90	September 1, 2025
Microsoft SQL Node Insert Problem - Bug Questions microsoft-sql	21	1605	January 22, 2024
Microsoft SQL node (insert) fails, but returns success Questions	17	1013	June 14, 2024
MSSQL - 'Insert' Missing basic functionality (null-handling, escape quotes, string-processing) Questions node	18	1675	June 27, 2021
Issue when inserting into a table in MS SQL Server Questions	3	2592	August 23, 2021

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

Related topics