{
  "name": "microsoftsql",
  "display_name": "Microsoft SQL",
  "description": "Get, add and update data in Microsoft SQL",
  "group": [
    "transform"
  ],
  "versions": [
    1.0
  ],
  "inputs": 1,
  "outputs": 1,
  "credentials": [
    {
      "name": "microsoftSql",
      "required": true
    }
  ],
  "properties": [
    {
      "name": "operation",
      "display_name": "Operation",
      "kind": "options",
      "required": false,
      "default": "insert",
      "description": "Execute an SQL query"
    },
    {
      "name": "query",
      "display_name": "Query",
      "kind": "string",
      "required": true,
      "default": "",
      "description": "The SQL query to execute. You can use n8n expressions and $1, $2, $3, etc to refer to the "
    },
    {
      "name": "options",
      "display_name": "Options",
      "kind": "collection",
      "required": false,
      "default": "",
      "description": "Comma-separated list of values to use as query parameters. Reference them in the query as $1, $2, $3, etc. You can drag values from the input panel on the left."
    },
    {
      "name": "table",
      "display_name": "Table",
      "kind": "string",
      "required": true,
      "default": "",
      "description": "Name of the table in which to insert data to"
    },
    {
      "name": "columns",
      "display_name": "Columns",
      "kind": "string",
      "required": false,
      "default": "",
      "description": "Comma-separated list of the properties which should used as columns for the new rows"
    },
    {
      "name": "table",
      "display_name": "Table",
      "kind": "string",
      "required": true,
      "default": "",
      "description": "Name of the table in which to update data in"
    },
    {
      "name": "updateKey",
      "display_name": "Update Key",
      "kind": "string",
      "required": true,
      "default": "id",
      "description": "Name of the property which decides which rows in the database should be updated. Normally that would be "
    },
    {
      "name": "columns",
      "display_name": "Columns",
      "kind": "string",
      "required": false,
      "default": "",
      "description": "Comma-separated list of the properties which should used as columns for rows to update"
    },
    {
      "name": "table",
      "display_name": "Table",
      "kind": "string",
      "required": true,
      "default": "",
      "description": "Name of the table in which to delete data"
    },
    {
      "name": "deleteKey",
      "display_name": "Delete Key",
      "kind": "string",
      "required": true,
      "default": "id",
      "description": "Name of the property which decides which rows in the database should be deleted. Normally that would be "
    }
  ],
  "source_path": "/home/mcochran/n8n/packages/nodes-base/nodes/Microsoft/Sql/MicrosoftSql.node.ts"
}