Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how

Wolfram Language & System Documentation Center

"MicrosoftSQL"

"MicrosoftSQL"

Listing of Supported Databases »

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

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

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 :

See Also

RelationalDatabase DatabaseReference DatabaseConnect DatabaseDisconnect

History

Introduced in 2020 (12.1)

Top [フレーム]