nodes/generated

Interface MicrosoftSqlNodeParameters

interface MicrosoftSqlNodeParameters {
    columns?: string;
    deleteKey?: string;
    operation?:
        | "update"
        | "delete"
        | "executeQuery"
        | "insert";
    query?: string;
    table?: string;
    updateKey?: string;
}

Properties§

readonly columns?: string

Comma-separated list of the properties which should used as columns for the new rows

readonly deleteKey?: string

Name of the property which decides which rows in the database should be deleted. Normally that would be "id". Default: "id"

readonly operation?: "update" | "delete" | "executeQuery" | "insert"

Default: "insert"

readonly query?: string

The SQL query to execute Type options: {"editor":"sqlEditor","sqlDialect":"MSSQL"}

readonly table?: string

Name of the table in which to insert data to

readonly updateKey?: string

Name of the property which decides which rows in the database should be updated. Normally that would be "id". Default: "id"