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

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit mssql.py