Microsoft SQL Server
SQL commands targeting a SQL Server database instance.
Type: mssql
Configuration
| Name | Required | Description |
|---|---|---|
MSSQL_CONNECTION_URI | yes | The server name which will be used to connect to the SQL instance, format: [protocol:]server[instance_name][,port] |
MSSQL_USER | yes | The database username |
MSSQL_PASS | yes | The database password |
MSSQL_DB | yes | The name of the database instance |
FIELD_SEPARATOR | no | Defaults to table output, using other character will suppress spaces |
Examples
Connection URI:
MSSQL_CONNECTION_URI=tcp:192.168.10.110,1490MSSQL_CONNECTION_URI=192.168.10.110- defaults to tcp and port 1433