delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/mssql/base.py, branch pr/320 github.com: zzzeek/sqlalchemy.git Use schema_name() for SQL Server default schema 2016-10-04T15:32:20+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-10-04T15:32:20+00:00 562e37ee7eaab8b19a9f081d4b170b95fce4f619 Changed the query used to get "default schema name", from one that queries the database principals table to using the "schema_name()" function, as issues have been reported that the former system was unavailable on the Azure Data Warehouse edition. It is hoped that this will finally work across all SQL Server versions and authentication styles. Change-Id: Ic11bd4162c0d6a60432ae44876e86512703c1f81 Fixes: #3810 
Changed the query used to get "default schema name", from one that
queries the database principals table to using the
"schema_name()" function, as issues have been reported that the
former system was unavailable on the Azure Data Warehouse edition.
It is hoped that this will finally work across all SQL Server
versions and authentication styles.

Change-Id: Ic11bd4162c0d6a60432ae44876e86512703c1f81
Fixes: #3810
Use SQL Server SERVERPROPERTY for version info w/ pyodbc 2016-10-04T15:17:26+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-10-04T15:17:26+00:00 f0ea9e37f94bd39fa4f0785dbdcd0ee1759c4a11 Updated the server version info scheme for pyodbc to use SQL Server SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which continues to be unreliable particularly with FreeTDS. Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce Fixes: #3814 
Updated the server version info scheme for pyodbc to use SQL Server
SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which
continues to be unreliable particularly with FreeTDS.

Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce
Fixes: #3814
Spelling fixes 2016-08-08T13:39:15+00:00 Ville Skyttä ville.skytta@iki.fi 2016-08-08T13:39:15+00:00 fd164a6c849289b81f29059dda822c3d5902e40e 






- Document how SQL Server does MAX with VARCHAR, NVARCHAR
2016-07-27T14:04:52+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-07-27T14:04:52+00:00

0d92f79fd86073203a2a956460140c311c85a396

Fixes #3760

Change-Id: I0613eb66bfdc9d7118688c74e29c8da322c3b4db





Fixes #3760

Change-Id: I0613eb66bfdc9d7118688c74e29c8da322c3b4db







Allow creating explicit non-clustered keys and indexes MS SQL.
2016-06-06T18:27:31+00:00

Saulius Žemaitaitis
saulius@zemaitaitis.lt

2016-04-12T03:16:45+00:00

a5f92314edd45a2e411b0f5b3c4d4bec0c7d92f8

mssql_clustered=False on Index, UniqueConstraint,
PrimaryKeyConstraint now renders NONCLUSTERED.
The default of mssql_clustered is now None.

Co-Authored-By: mike bayer <mike_mp@zzzcomputing.com>
Change-Id: Id6b8d840e355be8f8fa72360cb4b6d2617ba72cf
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/252





mssql_clustered=False on Index, UniqueConstraint,
PrimaryKeyConstraint now renders NONCLUSTERED.
The default of mssql_clustered is now None.

Co-Authored-By: mike bayer <mike_mp@zzzcomputing.com>
Change-Id: Id6b8d840e355be8f8fa72360cb4b6d2617ba72cf
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/252







Fix label referencing in SQL Server OFFSET logic
2016-05-10T16:55:23+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-05-10T16:49:56+00:00

0604116814a862d4d9dbc1a8866a2a3b0126caf1

Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711





Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711







ReST fix: missing backtick
2016-03-21T10:00:49+00:00

Marius Gedminas
marius@gedmin.as

2016-03-21T10:00:49+00:00

e3abb63293be80379d20b4c3f0d1cd093459a9eb

Fixes a misrendering at http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#nullability:




Fixes a misrendering at http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#nullability:






- Added basic isolation level support to the SQL Server dialects
2016-03-15T21:47:34+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-03-15T21:47:34+00:00

4d147c3b169a3d57c0528b0a2633a30866fcb2f9

via :paramref:`.create_engine.isolation_level` and
:paramref:`.Connection.execution_options.isolation_level`
parameters.  fixes #3534





via :paramref:`.create_engine.isolation_level` and
:paramref:`.Connection.execution_options.isolation_level`
parameters.  fixes #3534







- add notes for pyodbc limitations with rowcount fixes #3675
2016-03-15T15:16:21+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-03-15T15:16:21+00:00

8bc370ed382a45654101fa34bac4a2886ce089c3












- happy new year
2016-01-29T16:20:22+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-01-29T16:20:22+00:00

859379e2fcc4506d036700ba1eca4c0ae526a8ee