推荐订阅源

尝试环境：.netfx2.0~4.8、.net core 3.1~5.0、SQL Server 2008 R2 SP1，发现.net版本之间及数据兼容模式如何设置没差异。

Flag	Name	Value	Description
1	DISABLE_DEF_CNST_CHK		Controls interim or deferred constraint checking.
2	IMPLICIT_TRANSACTIONS		For dblib network library connections, controls whether a transaction is started implicitly when a statement is executed. The IMPLICIT_TRANSACTIONS setting has no effect on ODBC or OLEDB connections.
4	CURSOR_CLOSE_ON_COMMIT		Controls behavior of cursors after a commit operation has been performed.
8	ANSI_WARNINGS	ON	Controls truncation and NULL in aggregate warnings.
16	ANSI_PADDING	ON	Controls padding of fixed-length variables.
32	ANSI_NULLS	ON	Controls NULL handling when using equality operators.
64	ARITHABORT		Terminates a query when an overflow or divide-by-zero error occurs during query execution.
128	ARITHIGNORE		Returns NULL when an overflow or divide-by-zero error occurs during a query.
256	QUOTED_IDENTIFIER	ON	Differentiates between single and double quotation marks when evaluating an expression.
512	NOCOUNT		Turns off the message returned at the end of each statement that states how many rows were affected.
1024	ANSI_NULL_DFLT_ON	ON	Alters the session's behavior to use ANSI compatibility for nullability. New columns defined without explicit nullability are defined to allow nulls.
2048	ANSI_NULL_DFLT_OFF		Alters the session's behavior not to use ANSI compatibility for nullability. New columns defined without explicit nullability do not allow nulls.
4096	CONCAT_NULL_YIELDS_NULL	ON	Returns NULL when concatenating a NULL value with a string.
8192	NUMERIC_ROUNDABORT		Generates an error when a loss of precision occurs in an expression.
16384	XACT_ABORT		Rolls back a transaction if a Transact-SQL statement raises a run-time error.

选项参考：https://docs.microsoft.com/en-us/sql/t-sql/statements/set-statements-transact-sql