尝试环境:.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