Tag: databases

NOT operator is used in the predicate

IN Operator is used in the predicate

Expression and/or functions are used on the indexed columns

Predicate is skipped. However, the SELECT clause has indexed columns

ORDER BY clause has NULL columns. However, NON UNIQUE index exists

WHERE LastName = 'S*'

WHERE LastName = 'S%'

WHERE LastName LIKE 'S*'

WHERE LastName LIKE 'S%'

DATETIME

SMALLDATETIME

INT

VARCHAR

The public role captures all default permissions for users in a database.

The public role cannot be dropped.

The public role is contained in every database, including msdb, tempdb, model, and all user databases except in the master database for security purposes.

The public role cannot have users, groups, or roles assigned to it.

2,147,483,647

2,147,483,648

4,294,967,295

4,294,967,296

2000/02/29

2000/03/01

44

An error is generated. A DATETIME value and an INT value cannot be added together. Use the DATEADD function for this purpose.

January 1, 1643

January 1, 1753

January 1, 1863

January 1, 1700

January 1, 1800

January 1, 1900

db_accessadmin

db_securityadmin

db_setupadmin

db_sysadmin

BIGINT

FLOAT

DECIMAL

MONEY

REAL

NUMERIC

128

256

512

1,024