Bits in SQL Server

Decimal-Binary Conversion

Decimal

Binary

Place Value

1

1

2⁰

2

10

2¹

4

100

2²

8

1000

2³

16

10000

2⁴

32

100000

2⁵

64

1000000

2⁶

128

10000000

2⁷

Value

Configuration

Description

1

DISABLE_DEF_CNST_CHK

Controls
interim or deferred constraint checking.

2

IMPLICIT_TRANSACTIONS

Controls
whether a transaction is started implicitly when a statement is executed.

4

CURSOR_CLOSE_ON_COMMIT

Controls
behavior of cursors after a commit operation has been performed.

8

ANSI_WARNINGS

Controls
truncation and NULL in aggregate warnings.

16

ANSI_PADDING

Controls
padding of fixed-length variables.

32

ANSI_NULLS

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

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

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 are defined not to allow nulls.

4096

CONCAT_NULL_YIELDS_NULL

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.