Microsoft SQL Server

https://www.microsoft.com/en-us/sql-server

Microsoft SQL Server is a relational database management system.

Installation

Required packages: pymssql

Drivers

pymssqlRecommended

pyodbc

PyPI Package: pymssql

mssql+pymssql://{username}:{password}@{host}:{port}/{database}

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 44/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Extended Aggregate Functions

The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.

MEDIANSTDDEV_SAMPVAR_SAMP

Troubleshooting

Common error messages you may encounter when connecting to or querying Microsoft SQL Server, along with their causes and solutions.

Authentication1 error

Connection3 errors

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit mssql.py