"MicrosoftSQL"Listing of Supported Databases »
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
BIT True or False BINARY, IMAGE, VARBINARY ByteArray DATE DateObject with Day granularity DATETIME, DATETIME2, SMALLDATETIME DateObject with Instant granularity DATETIMEOFFSET DateObject with Instant granularity and time zone support DECIMAL, NUMERIC Real with fixed precision BIGINT, INTEGER, SMALLINT, TINYINT Integer FLOAT, REAL Real CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML String TIME TimeObject
Introduced in 2020