cl-mssql

API Reference

mssql

MSSQL

  • Variable *DATABASE*
    nil
  • Class DATABASE-CONNECTION
    DBPROC
    EXTERNAL-FORMAT
  • Function CONNECT (database user password host &key (external-format :utf-8))
    Connects to `database` on `host` using `user` and `password`. The external format defaults to :utf-8. A CLOS object of type 'database-connection is returned.
  • Function CONNECTED-P (connection)
    Is `connection` available?
  • Function DISCONNECT (connection)
    Disconnect from `connection`.
  • Function DISCONNECT-TOPLEVEL
    Disconnects from *database*
  • Function CONNECT-TOPLEVEL (database user password host &key (external-format :utf-8))
    Connects to `database` on `host` using `user` and `password`. The connection is bound to the special variable *database*
  • Macro WITH-CONNECTION ((database user password host &key (external-format :utf-8)) &body body)
    Connects to `database` on `host` using `user` and `password`. Inside of `body`, the connection is bound to the special variable *database*
  • Function QUERY (query &key (connection *database*) (format :lists))
    Sends in `query` to `connection`, return the result as `format`. Format can be any keyword found in *query-formats*.
  • Function EXECUTE (query &key (connection *database*))
  • Macro WITH-TRANSACTION ((&key (connection '*database*) name) &body body)
    Execute the body within a database transaction, committing when the body exits normally, and aborting otherwise. An optional name can be given to the transaction, which can be used to force a commit or abort before the body unwinds.
  • Function ROLLBACK-TRANSACTION (transaction)
    Immediately rollback an open transaction.
  • Function COMMIT-TRANSACTION (transaction)
    Immediately commit an open transaction.
  • Function CALL-REMOTE-PROCEDURE (name &rest params)