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] PageNavigation event parameter-based queries access rights and ad hoc queries, inserting best practices default parameter values duplicate parameter names dynamic SQL marking parameters NULL values parameter-based updates Parameters collections query parameters adding capturing definition of SELECT queries SqlParameter class SqlParameterCollection class Unicode literals validation overview of sample application Value property what can be parameterized parameters queries [See parameter-based queries.] report parameters creating definition of sample application Parameters collections Parameters property (SqlCommand object) 2nd parent/child relationships updating Parse function 2nd Password keyword passwords, System Administrators patches percent sign (%) performance CLR executable performance, evaluating overview of with SQL Profiler stored procedures TVFs (table-valued functions) UDTs (user-defined types) connection pools DBMSs .NET Framework acceptable speed ADO DAO developer performance JET MDAC stack, sharing overview of performance metrics shareable and reusable components shared code team development performance counters activating selecting 2nd SqlClient performance counters viewing with Server Explorer Query plans SQL Server Express Edition 2nd performance counters activating selecting SqlClient performance counters viewing with Server Explorer PerformBack method permissions, denying Persist Security Info keyword persistent connections 2nd personas (security) pick lists, prompting with PID (process identifier) plans, Query [See Query plans.] polling pools [See connection pools.] populating data structures DataSet Load method DataSets with DataTable objects DataTable Load method design hard-coding DataTable objects InfoMessage messages OUTPUT and RETURN value parameters overview of resultset elements 2nd SqlDataAdapter Fill method ports Position property (BindingSource class) 2nd PositionChanged event Prepare method 2nd PRIMARY KEY constraint primary keys changing defining GUIDs (globally unique identifiers) multi-column primary keys PRIMARY KEY constraint primary key/foreign key relationships Print event Privacy Act of 1974 prjSampleVSReport application adding to project laying out procedures, stored [See stored procedures.] ProcessingMode property (Report Viewer class) ProductByProfit report Data Sources, creating formatting background color expressions laying out Report Viewer control configuration testing Professional Edition (Visual Studio) Profiler [See SQL Profiler.] projects adding reports to specifications PromptAreaCollapsed property (Report Viewer class) prompting for parameter values with pick lists properties [See specific properties.] protection [See security, application design.] protocols Named Pipes Shared Memory TCP/IP (Transmission Control Protocol/Internet Protocol) VIA (Virtual Interface Adaptor) |