update_data
Modifies records in an MSSQL Database table by specifying updates with a required WHERE clause for precise and secure data changes. Ideal for targeted database management tasks.
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'" |