# `MSSQLConnection`

The MSSQLConnection class is accessible via the `sqlobject.mssql.mssqlconnection` module.

## Attributes

#### a `supportTransactions`

    True

#### a `limit_re`

    <_sre.SRE_Pattern object at 0x98c23c0>

#### a `SHOW_COLUMNS`

    "\n        select\n                name,\n                length,\n                (       select name\n                        from systypes\n                        where cast(xusertype as int)= cast(sc.xtype as int)\n                ) datatype,\n                prec,\n                scale,\n                isnullable,\n                cdefault,\n                m.text default_text,\n                isnull(len(autoval),0) is_identity\n        from syscolumns sc\n        LEFT OUTER JOIN syscomments m on sc.cdefault = m.id\n                AND m.colid = 1\n        where\n                sc.id in (select id\n                        from sysobjects\n                where name = '%s')\n        order by\n                colorder"

#### a `SHOW_TABLES`

    "SELECT name FROM sysobjects WHERE type='U'"

#### a `HAS_IDENTITY`

    "\n       select 1\n       from INFORMATION_SCHEMA.COLUMNS\n       where TABLE_NAME = '%s'\n       and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1\n    "

#### a `schemes`

    ['mssql']

#### a `dbName`

    'mssql'

## Methods

#### f `__init__(self, db, user, password='', host='localhost', port=None, autoCommit=0, **kw)` ...

#### f `insert_id(self, conn)` ...

insert_id method.

#### f `makeConnection(self)` ...

#### f `createReferenceConstraint(self, soClass, col)` ...

#### f `createColumn(self, soClass, col)` ...

#### f `createIDColumn(self, soClass)` ...

#### f `createIndexSQL(self, soClass, index)` ...

#### f `joinSQLType(self, join)` ...

#### f `tableExists(self, tableName)` ...

#### f `addColumn(self, tableName, column)` ...

#### f `delColumn(self, sqlmeta, column)` ...

#### f `columnsFromSchema(self, tableName, soClass)` ...

#### f `guessClass(self, t, size, precision, scale)` ...

Here we take raw values coming out of syscolumns and map to SQLObject class types.

#### f `server_version(self)` ...

Get server version: 8 - 2000 9 - 2005 10 - 2008 11 - 2012

#### f `can_use_max_types(self)` ...

#### f `can_use_microseconds(self)` ...

#### f `__del__(self)` ...

See the source for more information.