update_data
Modify records in MSSQL database tables by specifying column updates and WHERE clause conditions to target specific data rows for changes.
Instructions
Updates data in an MSSQL Database table using a WHERE clause. The WHERE clause must be provided for security.
Input 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'" |
Input Schema (JSON Schema)
{
"properties": {
"tableName": {
"description": "Name of the table to update",
"type": "string"
},
"updates": {
"description": "Key-value pairs of columns to update. Example: { 'status': 'active', 'last_updated': '2025-01-01' }",
"type": "object"
},
"whereClause": {
"description": "WHERE clause to identify which records to update. Example: \"genre = 'comedy' AND created_date <= '2025-07-05'\"",
"type": "string"
}
},
"required": [
"tableName",
"updates",
"whereClause"
],
"type": "object"
}