Skip to main content

MssqlExecQuery

This activity executes a specified SQL query on a Microsoft SQL Server database.

Core Functions​

  • Accepts a SQL query as input
  • Sends the query to the connected MSSQL database
  • Executes the query on the database server
  • Returns the result of the executed query

Inputs​

  • Query: Represents the SQL query that will be executed on the MSSQL database
    Type: String

Outputs​

  • Output: Returns the result of the executed query
    Type: DataTable

Short Technical Summary​

A database operation activity that executes a provided SQL query on a connected MSSQL database and returns the resulting data as a DataTable.