C

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]

cache
     cached Query plans
     custom report cache tables, building
CAL (Client Access License)
callback 2nd
Cancel method
CancelEdit method
canceling operations
capturing parameters
     prompting for parameter values
     prompting with pick lists
Cartesian products
CASCADE constraint
case-sensitive queries
Caution method
ChangeDatabase method
ChangePassword method
char data type 2nd
CHECK constraint 2nd
child/parent relationships
choosing
     application architectures
     connection scope
     connection strategy
     ConnectionStrings
     data access interfaces
         data access providers
         SQLEv (SQL Server Everywhere Edition)
     data access providers
    DBMSs (database management systems)
         client considerations
         maintenance and administration
         multi-user issues
         overview of
         performance
         scalability
         server considerations
         SQL Server costs
         SQL Server security
         transactions-per-second limits
     Query methods
class diagrams
classes
     BindingNavigator
     BindingSource
         events
         methods
         properties
         typical data binding scenarios
     class diagrams
     DataGridView
     DataView
     LocalReport
         events
         methods
         properties
     names
     ProgressBar
    Report Viewer
         configuring
         events
         methods
         overview of
         properties
    ServerReport
         accessing on Reporting Services
         methods and functions
         parameters 2nd
         rendering
     SqlBulkCopy
     SQLClientFactory
     SqlCommand
     SqlConnection
     SqlConnectionStringBuilder
     SqlContext
     SqlDataAdapter
         Fill method
         properties
         Update method
         updates
     SqlDataReader
     SqlDependency
     SqlError
     SqlErrorCollection
     SqlException
     SqlParameter 2nd
         access rights and
         best practices
         default parameter values
         duplicate parameter names
         dynamic SQL
         marking parameters
         NULL values
         Parameters collections
         ResetDbType method
         ResetSqlType method
         Unicode literals
         validation
         Value property
         what can be parameterized
     SqlParameterCollection 2nd
     SqlTransaction
clauses [See also statements, ALTER PROCEDURE.]
     COLLATE
     ORDERBY
     WHERE
Clear method
ClearAllPools method
ClearPool method
click-through reports
Client Access License (CAL)
client statistics
client/server architectures
     advantages/disadvantages
     building
     connection management
     connection pools
     data binding
     data entry paradigms
     data retrieval
     data storage limits
     data validation
     definition of
     hybrid architectures
     server-side cursors
     stored procedures
     temporary tables
clients
     client statistics
    client/server architectures
         advantages/disadvantages
         building
         connection management
         connection pools
         data binding
         data entry paradigms
         data retrieval
         data storage limits
         data validation
         definition of
         hybrid architectures
         server-side cursors
         stored procedures
         temporary tables
     competing demands on
     definition of 2nd
     SNC (SQL Server Native Client)
     SqlClient
Clone function
Close method 2nd 3rd
CloseConnection CommandBehavior (ExecuteReader function)
closing connections 2nd
     automatically
     connection pool connections 2nd
CLR executables
     ADO.NET
         Querying data
         returning data/messages
         SqlContext connection
         transactions
     aggregates 2nd
         CLR SUMUSD example
         definition of
         testing
     building
     debugging
     dependencies
     deploying
         executable dependencies, managing
         functions
         profiling deployment process
     designing
     enabling
    evaluating performance of
         overview of
         with SQL Profiler
         TVFs (table-valued functions)
     examples
     functions
         addressing in T-SQL
         deploying
         TVFs (table-valued functions)
     overview of 2nd
     performance issues
     security
     stored procedures
         compared to functions
         CountWords example
         creating
         performance
         returning resultsets with SqlContext class
         testing
     suitability for Visual Basic .NET development
     suitability for Visual Studio development
     test scripts
         creating
         executing
     triggers 2nd
         creating
         INSERTED and DELETED pseudo tables
         updates
     UDTs (user-defined types)
         AddLoan
         challenges of
         debugging
         instantiating UDT variables
         IsNull property
         methods
         Null property
         NULL values
         Parse function
         performance tuning
         public properties 2nd
         public structure declaration
         referencing
         referencing and updating values
         SELECT queries
         SqlUserDefinedTypeAttribute
         stepping through code
         templates
         ToString function
         typICurrencyV2 UDT
         user-defined serialization
         validating data
         when to use
    viewing
         with Server Explorer
         with SQL Server Management Studio Object Explorer
     when to use
COLLATE clause
collating sequences (SQL Server)
collections
     DataBindings
     Parameters
color of reports
columns
     aliases
     binding rules to
     constraints 2nd
     definition of
     hiding
     identifiers
    Identity columns
         concurrency management
         definition of
     naming
     order of, changing
     SqlDataReader columns, fetching
     strongly typed data columns
CommandBehaviors (ExecuteReader function)
     CloseConnection
     Default
     KeyInfo
     SchemaOnly
     SequentialAccess
     SingleResult
     SingleRow
CommandBuilder
     action commands, generating
     adding to applications
     capabilities of
     concurrency management
     example of
     wizard dependency on
commands [See methods and functions, Accumulate; statements, ALTER PROCEDURE.]
CommandText property (SqlCommand object)
CommandTimeout property (SqlCommand object) 2nd
CommandType property (SqlCommand object)
comments
common instances (SQL Server Express Edition)
Common Language Runtime (CLR) executables [See CLR executables, ADO.NET.]
community tech preview (CTP) releases
CompareAllSearchableValues setting (ConflictOption property)
CompareRowVersion setting (ConflictOption property)
comparing NULL values
CompletedSynchronously property (IAsyncResult interface)
complex control binding
complex data binding
concatenated T-SQL expressions
concatenating strings
concatenation operator (&)
concurrency management 2nd
     CommandBuilder
     design issues
     Identity column values
         @@Identity global variable
         ADO.NET
         parent/child relationship updates
         retrieving new Identity values
         SQL Server
     overview of
     Timestamp columns
Configuration Manager (SQL Server) 2nd
configuring
     connection pool keywords
     Report Viewer control
    server connections
         for Internet access
         static versus dynamic ports
         Surface Area Configuration (SAC) tool
     SQL Profiler
     TableAdapters
    Visual Studio
         custom project templates
         online or local help
         Options dialog
         saving and loading custom configurations
         Server Explorer
ConflictOption property (CommandBuilder)
connection pools 2nd
     activating/tuning/disabling
     for client/server applications
     closing connections
     configuring keywords
     connection timeouts
     just-in-time (JIT) connections
     monitoring
     options
     overflow
     for web applications
Connection Properties dialog
Connection property
     SqlCommand object 2nd
     SqlDataAdapter class
Connection Timeout keyword
connections
     client/server connection management
     closing 2nd 3rd
     connection pools 2nd
         activating/tuning/disabling
         for client/server applications
         closing connections
         configuring keywords
         connection timeouts
         just-in-time (JIT) connections
         monitoring
         options
         overflow
         for web applications
    ConnectionStrings
         building for data access providers
         building with SqlConnectionStringBuilder class
         building with Visual Studio
         connection objects
         connection pool keywords
         definition of
         keywords and aliases 2nd
         persisting
         security
         server name keyword
     establishing 2nd
     events
     exception handling
         SqlException class
         types of exceptions
     just-in-time (JIT) strategies
     limitations
     MARS
     methods
     opening 2nd
     persistent connections
     properties
     scope
     security 2nd
    server configuration
         for Internet access
         static versus dynamic ports
         Surface Area Configuration (SAC) tool
    SQL Server connections
         connection pooling
         connection strategies
         data access interface role
         debugging
         MARS (Multiple Active Resultsets)
         opening
         overview of
         protocols
         server state, managing
     SqlConnection objects
     SqlContext
     timeouts
ConnectionStrings
     building for data access providers
     building with SqlConnectionStringBuilder class
     building with Visual Studio
     connection objects
     connection pool keywords
     definition of
     keywords and aliases 2nd
     persisting
     security
     server name keyword
constraints 2nd 3rd
constructors
     New (SqlCommand object)
consuming Web Services
ContinueUpdateOnError property (SqlDataAdapter class)
controls [See also classes, BindingNavigator; Toolbox (Visual Studio).]
     BindingNavigator
     BindingSource
         events
         methods
         properties
         typical data binding scenarios
     DataGridView
     DataSet
     deprecated data access controls
     finding
     overview of
     ProgressBar
    Report Viewer
         configuring
         events
         methods
         overview of
         properties
     shareable and reusable components
    TableAdapter
         generated parameters, managing
         parameters, configuring with Visual Studio
         stored procedures
         updating tables with
converting RDL to RDLC
ConvertToDollars function
counters [See performance counters, activating.]
CountWords stored procedure
CountWordsInString function
CREATE PROCEDURE statement
CREATE RULE statement 2nd
CreateParameter function 2nd
criteria pane (Query Designer)
Crystal Report Services
CTP (community tech preview) releases
Current property (BindingSource class)
CurrentChanged event
CurrentItemChanged event
CurrentPage property (Report Viewer class)
cursor data type
cursors
     cursor data type
     server-side cursors
         ADO.NET implementation of
         creating
         disadvantages of
         dynamic cursors
         fetching data from
         fetching entire cursor
         forward-only cursors
         importance of
         keyset cursors
         managing
         opening, closing, and reopening connections
         static cursors
         updating
custom controls, binding to
custom report cache tables, building
custom Visual Studio configurations
     creating with Options dialog
     custom project templates
     online or local help
     saving and loading
CustomerByState stored procedure 2nd
CustomerUpdate stored procedure
CustomerUpdate1 stored procedure