update_data
Modifies existing records in an MSSQL database table by applying specified changes to columns where conditions defined in a required WHERE clause are met.
Instructions
Updates data in an MSSQL Database table using a WHERE clause. The WHERE clause must be provided for security.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Name of the table to update | |
| updates | Yes | Key-value pairs of columns to update. Example: { 'status': 'active', 'last_updated': '2025-01-01' } | |
| whereClause | Yes | WHERE clause to identify which records to update. Example: "genre = 'comedy' AND created_date <= '2025-07-05'" |