n8n-nodes-azure-sqlInstall

Summary

Insert rows into an Azure SQL table using Entra ID authentication.

Inputs

• server (required) — The Azure SQL Server hostname (e.g., myserver.database.windows.net).
• database (required) — The database name to connect to.
• table (required) — Name of the table to perform the insert on.
• columns (required) — Comma‑separated list of column names (e.g., column1, column2, column3).
• values (required) — Comma‑separated list of values to insert (e.g., 'value1', 'value2', 'value3'). Values must be valid SQL literals.
• additionalOptions — Additional connection options. All are optional with sensible defaults; see sub‑options below for details.

Output shape

Each executed item returns an object with a json field containing:

The node returns an array where each element corresponds to an input item. For the Insert operation each element’s json includes: success flag, number of rows affected, and the operation type.

Examples

Example 1: Insert a single row

Set server, database, table, columns = 'id,name', values = '1, ''John Doe''' (note proper quoting).