Skip to content
One platform. From customer conversation to completed work.Take a closer look
All connections
Data & Docs · CONNECTION

Microsoft SQL Server + NodeHub

Run SQL queries and insert, update or delete rows in an external SQL Server database.

Explore 4 workflow actions for Microsoft SQL Server, including account permissions and operation limits.

0 read actions4 write actions
WORKFLOW ACTIONS

What you can configure.

Choose an action in the workflow builder, connect an account, and map its inputs. These actions are available in the catalog; your account access and a successful test determine whether they work for your setup.

Delete rows

Write

Delete up to 1000 rows matching one equality condition and return the exact affected-row receipt.

Permissions and limits

Account permissions

  • DELETE on the table

Operation limits

  • When more than 1000 rows match, SQL Server chooses the affected rows without an ordering guarantee.

A repeated request may repeat the external action. Review the previous result before retrying a write.

Execute SQL query

Write

Run parameterized T-SQL against the selected SQL Server database.

Permissions and limits

Account permissions

  • Privileges required by the SQL statement

Operation limits

  • SQL may change data. Use a database role with only the privileges this workflow needs.
  • At most 1000 returned rows and 2 MB are emitted. Add TOP or another server-side predicate when the database must avoid producing a larger result.
  • Cast high-precision decimal results to varchar so workflow JSON keeps every digit.
  • A lost write response is marked uncertain and not repeated.

A repeated request may repeat the external action. Review the previous result before retrying a write.

Insert row

Write

Insert one row and return the exact affected-row receipt.

Permissions and limits

Account permissions

  • INSERT on the table

A repeated request may repeat the external action. Review the previous result before retrying a write.

Update rows

Write

Update up to 1000 rows matching one equality condition and return the exact affected-row receipt.

Permissions and limits

Account permissions

  • UPDATE on the table

Operation limits

  • When more than 1000 rows match, SQL Server chooses the affected rows without an ordering guarantee.

A repeated request may repeat the external action. Review the previous result before retrying a write.

SETUP

Start with a controlled test.

01Connect the intended account

Use the account and permissions required for your process. Review the connection check before configuring a workflow action.

02Review inputs and access

Select a listed operation and map its required inputs. Use test records and add a human approval before writes that need review.

03Confirm the result

Inspect step outputs and confirm the result in Microsoft SQL Server. A saved workflow is not a completed provider action.

Follow the workflow quickstart
EXPLORE YOUR STACK

More in Data & Docs.

AgentBrainsAgifyAinoflow ConvertAirparser
Microsoft SQL Server integration | NodeHub