n8n-nodes-azure-sqlInstall

Summary

Update rows in an Azure SQL Database table using a SET clause and optional WHERE filter.

Inputs

• server (required) — The Azure SQL Server hostname
• database (required) — The database name to connect to
• table (required) — Name of the table to perform operation on
• setValues — SET clause for UPDATE query (e.g., 'column1 = 'value1', column2 = 'value2')
• whereClause — WHERE clause for the query (without WHERE keyword). If omitted, no filter is applied.
• additionalOptions — Optional connection and runtime settings: connectionTimeout (ms), debug, encrypt, port (default 1433), requestTimeout (ms), trustServerCertificate (default true).

Output shape

array

One result object per input data item. Emits { success: boolean, rowsAffected: integer, operation: 'update' } on successful execution. Errors halt unless 'Continue on Fail' is enabled. Connection uses Entra ID authentication (app registration or managed identity) with parameters from additionalOptions governing the connection configuration.

Examples

Example 1: Update a single row where ID = 5

server: 'myserver.database.windows.net', database: 'mydb', table: 'Users', setValues: 'Status = 'Active'', whereClause: 'ID = 5'