Home

	Expand Search

Reference Manual Volumes 1 - 4 (Online Only)

Chapter 4 Expressions, Identifiers, and Wildcard Characters

Chapter 4

Expressions, Identifiers, and Wildcard Characters

This chapter describes Transact-SQL expressions, valid identifiers, and wildcard characters.

Expressions

Size of expressions

Arithmetic and character expressions

Relational and logical expressions

Operator precedence

Arithmetic operators

Bitwise operators

String concatenation operator

Comparison operators

Nonstandard operators

Using any, all and in

Negating and testing

Ranges

Using nulls in expressions

Connecting expressions

Using parentheses in expressions

Comparing character expressions

Using the empty string

Including quotation marks in character expressions

Using the continuation character

Identifiers

Tables beginning with # (temporary tables)

Case sensitivity and identifiers

Uniqueness of object names

Using delimited identifiers

Identifying tables or columns by their qualified object name

Determining whether an identifier is valid

Renaming database objects

Using multibyte character sets

Pattern matching with wildcard characters

Using not like

Case and accent insensitivity

Using wildcard characters

Using multibyte wildcard characters

Using wildcard characters as literal characters

Using wildcard characters with datetime data