Microsoft SQL Server
Microsoft SQL Server (MSSQL) is a popular relational database system.
This component allows you to query an MSSQL database.
Connections¶
MS SQL Server Connection {#basic}¶
Authenticate requests to a Microsoft SQL Server.
The MS SQL Server username and password can be put directly into a connection, alongside the database host, port, and database name.
| Input | Comments | Default |
|---|---|---|
| Host | Provide a string value for the address that your database server is hosted on. | |
| Port | Provide a string value of the port your database server is exposing. | 1433 |
| Database | Provide a string value for the name of the database. | |
| Connection Timeout | The number of milliseconds before the attempt to connect is considered failed. | 15000 |
| Username | ||
| Password |
Actions¶
Execute Stored Procedure {#execute}¶
Execute a stored procedure on a Microsoft SQL Server Database
| Input | Comments | Default |
|---|---|---|
| Stored Procedure | The name of the stored procedure to execute. | |
| Timeout | The number of milliseconds to wait for a response from the server. If the timeout expires before the server responds, an error will be thrown. | 60000 |
| Connection |
Query {#query}¶
Interact with a Microsoft SQL Server Database
| Input | Comments | Default |
|---|---|---|
| Query | Provide a string containing a query that will be executed by the Microsoft SQL-Server database. You can pass in optional named parameters using the '@variable' operator. | SELECT * FROM Customers WHERE customerId = @id |
| Parameters | Optional parameters to insert into a query. | |
| Parameters Object | Optional parameters to insert into a query. This should be a key-value object. Values from this object will be merged with Parameters inputs. | |
| Timeout | The number of milliseconds to wait for a response from the server. If the timeout expires before the server responds, an error will be thrown. | 60000 |
| Connection |