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.