mssql.* slots
12 slots, each with its own page and JSON declaration. See how this reference is built.
| Slot | Description |
|---|---|
mssql.connect |
Opens a SQL Server connection. |
mssql.create |
Inserts rows through the current SQL Server connection. |
mssql.delete |
Deletes rows through the current SQL Server connection; include a [where] child unless intentionally deleting every row in the table. |
mssql.execute |
Executes SQL on the current SQL Server connection. |
mssql.execute-batch |
Executes a batch SQL script on the current SQL Server connection. |
mssql.read |
Reads rows through the current SQL Server connection. |
mssql.scalar |
Executes SQL and returns a scalar value from the current SQL Server connection. |
mssql.select |
Executes a SELECT query on the current SQL Server connection. |
mssql.transaction.commit |
Commits the current SQL Server transaction. |
mssql.transaction.create |
Creates a SQL Server transaction. |
mssql.transaction.rollback |
Rolls back the current SQL Server transaction. |
mssql.update |
Updates rows through the current SQL Server connection; use [where] to constrain affected rows. |