Features of the Microsoft ODBC Driver 11 for SQL Server on Windows
The ODBC Driver for SQL Server contains all the functionality of the SQL Server Native Client ODBC driver that shipped in SQL Server 2012. For more information, see SQL Server Native Client Programming. The SQL Server Native Client ODBC driver is based on the ODBC driver that ships in the Windows operating system. For more information, see Windows Data Access Components SDK.
This release of the ODBC Driver for SQL Server contains the following new features:
In SQL Server, the -y0 option for Sqlcmd.exe caused output is truncated at 1 MB if display_width was 0.
Beginning in the ODBC Driver 11 for SQL Server, there is no limit on the amount of data that retrieved in a single column when –y0 is specified. Sqlcmd.exe now streams columns as large as 2 GB (SQL Server data type maximum).
Another difference is that a combination of -h -y0 now produces an error that reports the options are incompatible. -h, which specifies the number of rows to print between the column headings and has never been compatible with -y0, and was ignored, though no headers were printed.
-y0 can cause performance issues on both the server and the network, depending on the size of data returned.