Skip to main content
Go to the Studio
SQL Server

SQL Server - Query

SQL Server - Query

Runs a SQL statement on a SQL Server database. It supports SELECT, INSERT, UPDATE, DELETE and other standard SQL statements. The results can be iterated with SQL Server: For each result or read directly from the action returns.


Options​

Connection​

Reference to the SQL Server: Connection action that will be used to run the query.

Query to be executed​

SQL statement to run on the SQL Server database, for example SELECT * FROM dbo.Clientes WHERE Ativo = 1.

Advanced options​

Transaction​

Option to select a previously created transaction to be used together with this query's execution.

Returns​

Javascript code​

js
actions["action-id"].query         // query that was executed (Text)
actions["action-id"].results       // query results (List)
actions["action-id"].resultsCount  // number of records returned (Number)

Field selection​

  • query — query that was executed (Text)
  • results — query results (List)
  • resultsCount — number of records returned (Number)

Rules and Conditions​

  • The Connection and Query fields are required.
  • results and resultsCount are relevant for SELECT statements.
  • For INSERT, UPDATE or DELETE statements, resultsCount returns 0.