Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)
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) |
Категории