时间：2021-07-01 10:21:17 帮助过：12人阅读
尝试环境：.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
.Net程序连接SQL Server默认会话选项备查
标签：back body effect commit network table sage check war