- 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|
|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|
|CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML||String|
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.