Q

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

QO (Query Optimizer) [See also Query plans.]
queries [See also Query Designer, criteria pane; statements, ALTER PROCEDURE.]
     ad hoc queries, integrating into applications 2nd
     adding parameters to
     aliasing
     BETWEEN expressions
     case-sensitive queries
     concatenated T-SQL expressions
     creating
     dates
     IN expressions
     LIKE expressions
     literals
    managing with Query Designer
         criteria pane
         Delete Query type
         derived tables
         derived views
         diagram pane
         Insert Results Query type
         Insert Values Query type
         JOIN behavior
         Make Table Query type
         overview of
         Select Query type
         SQL pane
         Update Query type
     NULL values
     parameter-based queries
         access rights and
         ad hoc queries, inserting
         best practices
         default parameter values
         duplicate parameter names
         dynamic SQL
         marking parameters
         NULL values
         Parameters collections
         SqlParameter class
         SqlParameterCollection class
         Unicode literals
         Value property
         what can be parameterized
    parameters
         capturing
         definition of
     pick-list queries
     QO (Query Optimizer)
     Query plans
         cached Query plans
         client statistics and alternate plans
         executing
         tuning
         viewing
     report queries
     resultsets, fetching
    SELECT queries
         CLR UDTs (user-defined types)
         creating
         executing
         generating with Query Designer
         joins 2nd
         limiting number of rows returned
         ORDER BY clause
         ordering rows returned
         parameters
         WHERE clause
     selecting methods
     SQL injection attacks, preventing
     sql_variant datatype
     UNION queries
     UPDATE queries
         BLOBs
         concurrency
         decimal and floating point numbers
         generating with Query Designer
         parameter-based updates
         SET clause
         strings
         strongly typed data columns
         updating cursors
    validation
         overview of
         sample application
Query Designer
     criteria pane
     Delete Query type
     derived tables
     diagram pane
     Insert Results Query type
     Insert Values Query type
     JOIN behavior
     Make Table Query type
     managing database views with
     overview of
     Select Query type
     SQL pane
     Update Query type
Query Optimizer (QO)
Query plans
     cached Query plans
     client statistics and alternate plans
     executing
     tuning
     viewing
Quick Basic
quiet installs (SQL Server)