Database Insert/Update Output Parameters
- Server: The name or IP address of the SQL Server instance.
- Database: The name of the database to connect to.
- User: The username for authentication.
- Password: The password for authentication.
- Port: The port number for the SQL Server instance (default is 1433).
- Table: The name of the table where data will be inserted or updated.
- Columns: The columns in the table where data will be inserted or updated.
- Values: The values to be inserted or updated in the specified columns.
- Primary Key: The primary key column(s) used to identify the record to be updated.
- Conflict Handling: How to handle conflicts (e.g., duplicate keys) during the insert/update operation.
- Transaction: Whether to use a transaction for the insert/update operation.
- Return Data: Whether to return the inserted/updated data as part of the response.