Showing content from http://reference.wolfram.com/language/ref/databaseconnection/MicrosoftSQL.html below:
MicrosoftSQL—Wolfram Documentation
WOLFRAM Consulting & Solutions
We deliver solutions for the AI eraâcombining symbolic computation, data-driven insights and deep technical expertise
- Data & Computational Intelligence
- Model-Based Design
- Algorithm Development
- Wolfram|Alpha for Business
- Blockchain Technology
- Education Technology
- Quantum Computation
WolframConsulting.com
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.
History
Introduced in 2020 (12.1)
RetroSearch is an open source project built by @garambo
| Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4