Beginning Transact-SQL With SQL Server 2000 and 2005

queries

functions, used in, 163

SQL Server Reporting Services, 418–423

writing, 84–86

Query Analyzer

Edit menu, 64

File menu, 64

launching, 64

object browser, 69

overview, 49, 63–64

Query menu, 64

SQL script and batch conventions, 65–68

Tools menu, 64

Query Designer tool

diagram pane, 53

executing query, 56

grid pane, 53

how it works, 52–63

overview, 52–53

SQL expression, modifying, 58–62

SQL pane, 53

table, viewing, 58

toolbar options, 57–58

query execution, 456

query processing

buffer cache, 44

described, 42–44

execution plan, 43

procedure cache, 44

query syntax, 109–110

questioning normalization rules, 42

QUOTENAME() function, 192, 479