SQL Server

SQL Server - Connection

SQL Server - Connection

Creates a connection to a SQL Server database from a connection configured in the workspace. The ID of this action is used as a reference by every other SQL Server action in the flow — such as SQL Server: Query, SQL Server: Begin transaction and SQL Server: Close connection.

Version 2.0

Options

Connection to use

Select the SQL Server connection previously registered in the workspace's Connections tab.

Version 1.0

Options

Connection string

Full connection string for the SQL Server database, for example Server=host,1433;Database=database;User Id=user;Password=password;.

Returns

This action has no direct returns. Its ID is used as a reference by the other SQL Server actions.

Rules and Conditions

• In Version 2.0, the Connection field is required and the connection must be configured beforehand in the workspace's Connections tab.
• In Version 1.0, the Connection string field is required.