SQLモード

(8.0.22)
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html

select @@sql_mode;

ALLOW_INVALID_DATES
ANSI_QUOTES
ERROR_FOR_DIVISION_BY_ZERO ★デフォルトON
HIGH_NOT_PRECEDENCE
IGNORE_SPACE
NO_AUTO_VALUE_ON_ZERO
NO_BACKSLASH_ESCAPES
NO_DIR_IN_CREATE
NO_ENGINE_SUBSTITUTION ★デフォルトON
NO_UNSIGNED_SUBTRACTION
NO_ZERO_DATE ★デフォルトON
NO_ZERO_IN_DATE ★デフォルトON
ONLY_FULL_GROUP_BY ★デフォルトON
PAD_CHAR_TO_FULL_LENGTH
PIPES_AS_CONCAT
REAL_AS_FLOAT
STRICT_ALL_TABLES
STRICT_TRANS_TABLES ★デフォルトON
TIME_TRUNCATE_FRACTIONAL

 

(19c)
ない模様

(13)
ない模様

(2019)
https://docs.microsoft.com/ja-jp/sql/database-engine/configure-windows/configure-the-user-options-server-configuration-option?view=sql-server-ver15

select @@options;


select case @@options & 1 when 1 then 'DISABLE_DEF_CNST_CHK ON' else 'DISABLE_DEF_CNST_CHK OFF' end
union all
select case @@options & 2 when 2 then 'IMPLICIT_TRANSACTIONS ON' else 'IMPLICIT_TRANSACTIONS OFF' end
union all
select case @@options & 4 when 4 then 'CURSOR_CLOSE_ON_COMMIT ON' else 'CURSOR_CLOSE_ON_COMMIT OFF' end
union all
select case @@options & 8 when 8 then 'ANSI_WARNINGS ON' else 'ANSI_WARNINGS OFF' end
union all
select case @@options & 16 when 16 then 'ANSI_PADDING ON' else 'ANSI_PADDING OFF' end
union all
select case @@options & 32 when 32 then 'ANSI_NULLS ON' else 'ANSI_NULLS OFF' end
union all
select case @@options & 64 when 64 then 'ARITHABORT ON' else 'ARITHABORT OFF' end
union all
select case @@options & 128 when 128 then 'ARITHIGNORE ON' else 'ARITHIGNORE OFF' end
union all
select case @@options & 256 when 256 then 'QUOTED_IDENTIFIER ON' else 'QUOTED_IDENTIFIER OFF' end
union all
select case @@options & 512 when 512 then 'NOCOUNT ON' else 'NOCOUNT OFF' end
union all
select case @@options & 1024 when 1024 then 'ANSI_NULL_DFLT_ON ON' else 'ANSI_NULL_DFLT_ON OFF' end
union all
select case @@options & 2048 when 2048 then 'ANSI_NULL_DFLT_OFF ON' else 'ANSI_NULL_DFLT_OFF OFF' end
union all
select case @@options & 4096 when 4096 then 'CONCAT_NULL_YIELDS_NULL ON' else 'CONCAT_NULL_YIELDS_NULL OFF' end
union all
select case @@options & 8192 when 8192 then 'NUMERIC_ROUNDABORT ON' else 'NUMERIC_ROUNDABORT OFF' end
union all
select case @@options & 16384 when 16384 then 'XACT_ABORT ON' else 'XACT_ABORT OFF' end
;

SSMSのデフォルト

DISABLE_DEF_CNST_CHK OFF
IMPLICIT_TRANSACTIONS OFF
CURSOR_CLOSE_ON_COMMIT OFF
ANSI_WARNINGS ON
ANSI_PADDING ON
ANSI_NULLS ON
ARITHABORT ON
ARITHIGNORE OFF
QUOTED_IDENTIFIER ON
NOCOUNT OFF
ANSI_NULL_DFLT_ON ON
ANSI_NULL_DFLT_OFF OFF
CONCAT_NULL_YIELDS_NULL ON
NUMERIC_ROUNDABORT OFF
XACT_ABORT OFF