🗄️ Microsoft SQL Server
Query and manipulate Microsoft SQL Server databases.
Overview
Query and manipulate Microsoft SQL Server databases directly from your workflows. Run SELECT queries, insert rows, update records, or delete data using T-SQL with variable interpolation.
Configuration
- Credential — select a Microsoft SQL Server credential
- Operation — Execute Query, Insert, Update, or Delete
- SQL Query — your T-SQL statement with
{{variable}}interpolation - Output Variable — name for storing query results
Accessing Results
{{$json.mssql_result}}— array of result rows{{$json.mssql_result[0].column_name}}— access specific column from first row