DF197: The GROUP BY ALL clause is used.

The topic describes the DF197 T-SQL code analysis rule.

Category

DEPRECATED

Message

The GROUP BY ALL clause is used.

Description

It is not recommended to use the GROUP BY ALL clause as it is deprecated and provided for backward compatibility only.

Noncompliant code example

SELECT code, SUM(VALUE) AS sum_value
FROM dbo.DemoTable
GROUP BY all code
GO

Compliant solution

SELECT code, SUM(VALUE) AS sum_value
FROM dbo.DemoTable
GROUP BY code
GO