Skip to main content

MssqlGetText

This activity retrieves a text value 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
  • Executes the query to retrieve a text result
  • Returns the resulting text value

Inputs​

  • Query: Represents the SQL query used to retrieve the text value from the MSSQL database
    Type: String

Outputs​

  • Output: Returns the text value retrieved from the database
    Type: String

Short Technical Summary​

A database retrieval activity that executes a SQL query on a connected MSSQL database and returns the resulting text value from the query result.