Details

  • Microsoft SQL Server is a relational database management system developed by Microsoft.

Connecting & Authenticating

  • When configuring MicrosoftSQL using DatabaseReference[URL["url"]], "url" is typically of the form "microsoftsql://user:password@host:port/name".
  • In DatabaseReference[assoc], typical elements of assoc include:
  • "Backend"the type of SQL backend used
    "Name"the name of the database
    "Host"the host serving the database
    "Port"the server port through which to access the database
    "Username"the username used to authenticate the database
    "Password"the password used to authenticate the database

Supported Types

  • BITTrue or False
    BINARY, IMAGE, VARBINARYByteArray
    DATEDateObject with Day granularity
    DATETIME, DATETIME2, SMALLDATETIMEDateObject with Instant granularity
    DATETIMEOFFSETDateObject with Instant granularity and time zone support
    DECIMAL, NUMERICReal with fixed precision
    BIGINT, INTEGER, SMALLINT, TINYINTInteger
    FLOAT, REALReal
    CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XMLString
    TIMETimeObject

Notes & Issues

  • MicrosoftSQL does not have native support for Boolean types; it uses 0 and 1 instead. For all logical operations, 0 is converted to False and 1 is converted to True.

Examples

Basic Examples  (1)

Create a MicrosoftSQL connection using the URL wrapper:

The canonical form of a DatabaseReference for MicrosoftSQL uses Association:

Introduced in 2020
 (12.1)