insert_row
Add new records to SQL Server tables by specifying column values. This tool inserts data into specified tables and returns the complete inserted row including generated identity columns.
Instructions
Insert a new row into a table.
Args:
table: Table name (can include schema: 'dbo.Users' or 'Users')
data: Dictionary of column names and values to insert
Returns:
Dictionary with:
- status: 'success' or error
- table: Full table name
- inserted: The inserted row (including generated identity columns)Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| data | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||