SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

set QUOTED_IDENTIFIER  on;
create table "select"(i int);
drop table "select";
set QUOTED_IDENTIFIER  off;
create table "select"(i int);
drop table "select";
Msg 102 Level 15 State 1 Line 2
Incorrect syntax near 'select'.

set QUOTED_IDENTIFIER  off;
if (1=0)
begin
    set QUOTED_IDENTIFIER  on;
end
create table "select"(i int);
drop table "select";
set QUOTED_IDENTIFIER  on;
if (1=0)
begin
    set QUOTED_IDENTIFIER  off;
end
create table "select"(i int);
drop table "select";
Msg 102 Level 15 State 1 Line 6
Incorrect syntax near 'select'.