Index

Symbols

[] (square brackets) wildcard, 65-66

^ (caret) character, 66

_ (underscore) wildcard, 64-65

| (pipe) symbol, 303

> (greater than operator), 47

< (less than operator), 47

>! (not greater than operator), 47

<! (not less than operator), 47

% (modulo operator), 76

% (percent sign) wildcard, 62-64

() (parentheses), WHERE clauses, 57

* (asterisk), 31

* (multiplication operator), 76

+ (addition operator), 76

- (subtraction operator), 76

= (equality operator), 47

>= (greater than or equal to operator), 47

<= (less than or equal to operator), 47

A

Abs() function, 89

access

control, 279-280

rights, 283-285

accounts, managing users, 281-283

adding rows to tables, 306

addition (+) operator, 76

aggregate functions

applying, 99

Avg(), 92-93 ...

Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.