mssql_bulk_insert
Insert multiple rows into Microsoft SQL Server tables using bulk operations for improved performance when handling large datasets.
Instructions
Insert multiple rows efficiently using bulk operations
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Array of objects representing rows to insert | |
| database | Yes | Database name | |
| encrypt | No | Use encrypted connection (default: true) | |
| password | Yes | Password for authentication | |
| port | No | Port number (default: 1433) | |
| server | Yes | MSSQL Server hostname or IP address | |
| table | Yes | Target table name | |
| trustServerCertificate | No | Trust server certificate (default: true) | |
| user | Yes | Username for authentication |
Input Schema (JSON Schema)
{
"properties": {
"data": {
"description": "Array of objects representing rows to insert",
"type": "array"
},
"database": {
"description": "Database name",
"type": "string"
},
"encrypt": {
"default": true,
"description": "Use encrypted connection (default: true)",
"type": "boolean"
},
"password": {
"description": "Password for authentication",
"type": "string"
},
"port": {
"default": 1433,
"description": "Port number (default: 1433)",
"type": "number"
},
"server": {
"description": "MSSQL Server hostname or IP address",
"type": "string"
},
"table": {
"description": "Target table name",
"type": "string"
},
"trustServerCertificate": {
"default": true,
"description": "Trust server certificate (default: true)",
"type": "boolean"
},
"user": {
"description": "Username for authentication",
"type": "string"
}
},
"required": [
"server",
"user",
"password",
"database",
"table",
"data"
],
"type": "object"
}