The topic describes the DF086 T-SQL code analysis rule.
STYLE
Redundant parentheses are used.
To avoid potential confusion, it is recommended to remove parentheses that are not used to specify the desired order of operations.
Using redundant parentheses in SQL code can make the code harder to understand for other developers and may lead to confusion or errors when maintaining or debugging the code in the future.
SELECT
*
FROM dbo.DemoTable
WHERE (id = 2);
SELECT
*
FROM dbo.DemoTable
WHERE id = 2;