Index

Symbols

+ (addition operator)

described, 367

precedence, 383

& (AND bitwise operator), 390

' (apostrophe), 349

:= (assignment operator, PL/SQL), 490

* (asterisk)

columns, selecting all, 242–243

outer joins, MS SQL Server 2000, 295–296, 299, 300–301

@ (at sign), 494

\ (backslash), 356

() (brackets), 198

^ (caret wildcard operator), 378

: (colon)

format templates, 349

host variables, 531

, (comma)

format templates, 349

multiple indexes, dropping, 161

Oracle 9i updates, 198

|| (concatenation operator)

described, 248, 368

precedence, 383

- (dash), 349

-- (dash, double), 94

/ (division operator)

described, 368

precedence, 383

. (dot notation)

C program, connecting, 534

decimals, 57

fully qualified names, 15

" (double quotes), 51

= (equal sign)

as assignment operator, 385–386

as comparison operator, 386

join condition, 281

outer joins, MS SQL Server 2000, 295–296

/\ (exclusive OR bitwise operator), 390–392

/ (forward slash)

format templates, 349

PL/SQL function, 517

> (greater than operator), 386

>= (greater than or equal to operator), 386, 388

< (less than operator), 386

<= (less than or equal to operator), 386, 388

% (modulo operator), 368, 371

* (multiplication operator)

described, 368

precedence, 383

~ (NOT bitwise operator), 383, 390

<>, !=, !<, !> (not equal to operators), 387

| (OR bitwise operator), 390

() (parentheses), 385

% (percent sign), 378

+ (plus operator)

concatenating, 248

outer joins, Oracle 9i, 294–295, 300

(+) (plus sign within parentheses), 298

# (pound sign), 84

## (pound sign, double), 84

; (semicolon)

C programming delimiter, 531

format templates, 349

PL/SQL statements, 490

' (single quote)

character literals, 51

date and time, handling, 67

numeric literals, 57

[] (square brackets), 378

- (subtraction operator), 367

+ (unary operator), 383, 384

_ (underscore wildcard operator), 378, 379–380




SQL Bible
Microsoft SQL Server 2008 Bible
ISBN: 0470257040
EAN: 2147483647
Year: 2005
Pages: 208

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net