sqlalchemy.dialects.mssql

package documentation
(source)

Undocumented

Module base .. dialect:: mssql :name: Microsoft SQL Server :full_support: 2017 :normal_support: 2012+ :best_effort: 2005+
Module information_schema No module docstring; 0/14 variable, 0/1 function, 2/4 classes documented
Module json Undocumented
Module provision Undocumented
Module pymssql .. dialect:: mssql+pymssql :name: pymssql :dbapi: pymssql :connectstring: mssql+pymssql://<username>:<password>@<freetds_name>/?charset=utf8
Module pyodbc .. dialect:: mssql+pyodbc :name: PyODBC :dbapi: pyodbc :connectstring: mssql+pyodbc://<username>:<password>@<dsnname> :url: https://pypi.org/project/pyodbc/

From __init__.py:

Class BIT MSSQL BIT type.
Class DATETIME2 Undocumented
Class DATETIMEOFFSET Undocumented
Class IMAGE Undocumented
Class JSON MSSQL JSON type.
Class MONEY Undocumented
Class NTEXT MSSQL NTEXT type, for variable-length unicode text up to 2^30 characters.
Class REAL Undocumented
Class ROWVERSION Implement the SQL Server ROWVERSION type.
Class SMALLDATETIME Undocumented
Class SMALLMONEY Undocumented
Class SQL_VARIANT Undocumented
Class TIME Undocumented
Class TIMESTAMP Implement the SQL Server TIMESTAMP type.
Class TINYINT Undocumented
Class UNIQUEIDENTIFIER No class docstring; 0/2 instance variable, 0/1 class variable, 1/1 method documented
Class VARBINARY The MSSQL VARBINARY type.
Class XML MSSQL XML type.
Function try_cast Create a TRY_CAST expression.
def try_cast(*arg, **kw): (source)

Create a TRY_CAST expression. :class:`.TryCast` is a subclass of SQLAlchemy's :class:`.Cast` construct, and works in the same way, except that the SQL expression rendered is "TRY_CAST" rather than "CAST":: from sqlalchemy import select from sqlalchemy import Numeric from sqlalchemy.dialects.mssql import try_cast stmt = select( try_cast(product_table.c.unit_price, Numeric(10, 4)) ) The above would render:: SELECT TRY_CAST (product_table.unit_price AS NUMERIC(10, 4)) FROM product_table .. versionadded:: 1.3.7