Microsoft Sql

Node: microsoftSql · Full type: n8n-nodes-base.microsoftSql · Version: 1.1

Credentials

microsoftSql (alias: @microsoft)

CREDENTIAL @microsoft = microsoftSql "My Microsoft Sql"

Operations

executeQuery

Parameter	Type	Default	Details
query	string	""	required

insert

Parameter	Type	Default	Details
table	string	""	required
columns	string	""

update

Parameter	Type	Default	Details
table	string	""	required
updateKey	string	"id"	required
columns	string	""

delete

Parameter	Type	Default	Details
table	string	""	required
deleteKey	string	"id"	required

Example

NODE "microsoftSql" @microsoft AS "Microsoft Sql" {
  operation: "executeQuery",
  query: {{ $json.query }},
  table: {{ $json.table }},
  updateKey: {{ $json.updateKey }},
  deleteKey: {{ $json.deleteKey }}
}