Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server 2016 (13.x) and later versions
This article describes breaking changes in the SQL Server 2016 (13.x) Database Engine and earlier versions of SQL Server. These changes might break applications, scripts, or functionalities that are based on earlier versions of SQL Server. You might encounter these issues when you upgrade.
The sample_ms column of sys.dm_io_virtual_file_stats
has expanded from an int to a bigint data type.
The TimeStamp column of sys.fn_virtualfilestats
has expanded from an int to a bigint data type.
Under database compatibility level 130, implicit conversions from datetime to datetime2 data types show improved accuracy by accounting for the fractional milliseconds, resulting in different converted values. Use explicit casting to datetime2 datatype whenever a mixed comparison scenario between datetime and datetime2 datatypes exists. For more information, see this Microsoft Support Article.
Under database compatibility level 130, operations that perform implicit conversions between certain numeric and datetime data types show improved accuracy and can result in different converted values. This includes usage of functions that require calculations such as DATEDIFF
and ROUND
. For more information, see this Microsoft Support Article.
For information about breaking changes in SQL Server 2014 (12.x), and in some earlier versions, see Breaking Changes to Database Engine Features in SQL Server 2014.
We accumulate and retain documentation for very old versions of Microsoft SQL Server, in sets of archived webpages. The archived webpages are not processed by search engines, such as bing.com and google.com. Yet you can see these archives at our Docs previous-versions/sql/ address:
These archives include the documentation for at least the following older versions:
SQL Server 2014 documentation is still available on our main Docs address.
SQL Server 2022 documentation is available on our main Docs address. Then, you can use the versioning dropdown near the top of the page, to select another version of interest.
For more information about the documentation for previous versions of SQL Server, see Previous versions of SQL Server documentation.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Introduction to SQL Server 2022 T-SQL enhancements - Training
SQL Server 2022 introduces a range of new features and enhancements, providing powerful tools and capabilities that optimize performance and offer better control on SQL objects manipulation and creation.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Database Engine: Breaking changes - SQL Server 2019
Breaking changes to database engine features in SQL Server 2019
Deprecated Database Engine features - SQL Server 2022
Find out about deprecated Database Engine features that are still available in SQL Server 2022 (16.x), but shouldn't be used in new applications.
Deprecated Database Engine features - SQL Server 2019
Find out about deprecated Database Engine features that are still available in SQL Server 2019 (15.x), but shouldn't be used in new applications.