Q


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




Beginning Transact-SQL with SQL Server 2000 and 2005
Beginning Transact-SQL With SQL Server 2000 and 2005
ISBN: 076457955X
EAN: 2147483647
Year: 2006
Pages: 131
Authors: Paul Turley

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