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 1. September 2025 um 07:48 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.

Thema		Antworten	Aufrufe
Add support for inserting multiple rows in Azure Dedicated SQL Pool Feature Requests microsoft-sql , mssql	0	90	1. September 2025
Microsoft SQL Node Insert Problem - Bug Questions microsoft-sql	21	1606	22. Januar 2024
Microsoft SQL node (insert) fails, but returns success Questions	17	1015	14. Juni 2024
MSSQL - 'Insert' Missing basic functionality (null-handling, escape quotes, string-processing) Questions node	18	1678	27. Juni 2021
Issue when inserting into a table in MS SQL Server Questions	3	2592	23. August 2021

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

Verwandte Themen