Is grouping of selection conditions supported in MSSQL?

Question

Transact SQL

Not very strong in SQL and for the purposes of my own knowledge I created a small table (roughly)

CREATE TABLE [test]
(
    [id] int,
    [column_A] int,
    [column_B] bit,
    [column_C] int,
    [column_D] bit,
    [column_Z] bigint
);

from which it is necessary to make a selection according to a number of conditions, by analogy with mathematical grouping (through brackets) in order to indicate the priority of performing operations. those. something like this:

SELECT * FROM [test]
WHERE [column_Z] = 3 AND (([column_A] = 2 AND [column_B] <> 0) OR ([column_C] = 2 AND[ columnD] <> 1))

From the example, you can see that the query SELECTinvolves a selection in which the conditions are grouped. In a sense, this should declare (I think so) the order in which the conditions are checked, is it? ... or SQL itself determines this order to optimize query execution and therefore the grouping of conditions will not work, i.e. brackets are ignored. Wednesday - MSSQL 2016.

Answer 1

Parentheses are naturally taken into account. But sql can implement the order of checks in its own way due to its knowledge of data insider.

Answer 2

Bitrix was specially created in such a way that only their developers understand what kind of heresy is written in the code, so that clients do not run to freelance

Answer 3

Only one drawback - Bitrix

Answer 4

This can theoretically be called code if you remove the html and bring it to PSR1|2 . The request /?_SERVER[DOCUMENT_ROOT]=/anydoes not return any errors? If so, then you still have a hole in the server settings.

Answer 5

Using array parameters requires good documentation, otherwise maintaining such code can be very difficult.

Answer 6

Why do you think he is bad? In fact, within the framework of the CMS you are using, it is completely generic code.
Apparently you should ask why Bitrix is ​​bad?