update_records
Set specified column values on rows in a SQL Server table that match a WHERE condition.
Instructions
Update matching records in a table with specified values (Update).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Dictionary of column-value pairs to set (e.g., {"status": "ACTIVE", "updated_at": "2026-08-19"}). | |
| table_name | Yes | Target table name. | |
| schema_name | No | Target schema name (default: 'dbo'). | dbo |
| where_clause | Yes | SQL WHERE clause expression (required to avoid full table updates). | |
| where_params | No | Positional parameter values for the WHERE clause placeholders. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||