FIX: Long query contains specific expressions receives syntax error if forced parameterization is enabled in SQL Server 2016

Symptoms

When you execute a query statement that contains more than 4,000 characters in SQL Server 2016, and the query statement contains some specific multi-word clauses, such as WITHIN GROUP, AT TIME ZONE; if forced parameterization is enabled, you may receive a syntax error.

Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.
Thuộc tính

ID Bài viết: 3175205 - Xem lại Lần cuối: 25-07-2016 - Bản sửa đổi: 1

Phản hồi