MssqlGetCollection
This activity retrieves a collection of data from a Microsoft SQL Server database using a specified SQL query.
Core Functions
- Accepts a SQL query as input
- Sends the query to the connected MSSQL database
- Retrieves the resulting dataset from the database
- Returns the retrieved data collection
Inputs
- Query: Represents the SQL query used to retrieve data from the MSSQL database
Type: String
Outputs
- Output: Returns the collection of records retrieved from the database
Type: DataTable
Short Technical Summary
A database retrieval activity that executes a SQL query on a connected MSSQL database and returns the resulting dataset as a DataTable collection.