[mssql.scalar]

mssql.scalar is a slot in the mssql namespace, in Hyperlambda, the language of Magic Cloud. Executes SQL and returns a scalar value from the current SQL Server connection.

• Value (sql-scalar), required: SQL statement to execute
• Returns: Resolves to the scalar result of the SQL statement
• Scope: requires mssql.connection - Requires an open SQL Server connection created by [mssql.connect]

Arguments

Required arguments come first, then the optional ones in the order they are declared.

Argument	Type	Required	Description
any node name	object	no	SQL parameter value; child name is used as the parameter name referenced by the SQL statement. Can be repeated.

JSON declaration

This is the complete declaration of mssql.scalar, as the running system describes it. It is also published as slot.json.

JSON declaration

{
  "name": "mssql.scalar",
  "description": "Executes SQL and returns a scalar value from the current SQL Server connection",
  "signature": {
    "input": {
      "kind": "sql-scalar",
      "description": "SQL statement to execute",
      "required": true,
      "mode": "ValueOrExpression"
    },
    "children": {
      "*": {
        "type": "object",
        "kind": "sql-parameter-value,text,number,boolean,date,guid,content,value",
        "description": "SQL parameter value; child name is used as the parameter name referenced by the SQL statement",
        "required": false,
        "mode": "ValueOrExpression",
        "cardinality": "ZeroOrMore",
        "role": "Arguments",
        "projection": "Value"
      }
    },
    "scope": {
      "requires": "mssql.connection",
      "description": "Requires an open SQL Server connection created by [mssql.connect]"
    },
    "output": {
      "mode": "Value",
      "description": "Resolves to the scalar result of the SQL statement"
    }
  }
}

---

← mssql.read

all mssql.* slots

mssql.select →