A

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]

access rights for parameter-based queries
accessing
     ADO classic ADTG Recordset
     flat files
     JETdatabases
Accumulate function
action commands
     INSERT
         Identity values
         NULL and DEFAULT values
     UPDATE
         BLOBs
         concurrency
         decimal and floating point numbers
         parameter-based updates
         SET clause
         strings
         strongly typed data columns
activating
     connection pools
     performance counters
ad hoc queries, integrating into applications 2nd
adCriteriaAllCols setting (Update Criteria property)
adCriteriaKey setting (Update Criteria property)
adCriteriaTimeStamp setting (Update Criteria property)
adCriteriaUpdCols setting (Update Criteria property)
Add method 2nd
Add New Table dialog
AddingNew event
AddLoan stored procedure
AddRange method 2nd
addressing objects
AddTrustedCodeModuleInCurrentAppDomain method
administration
     administrative functions
         Auto Close option
         backups
         importing/exporting data
         .MDFdatabase files, attaching
     DBMSs
     SQL Server Express Edition 2nd
ADO
     ADTG Recordset, accessing
     class diagrams
     data sources
     history of
     overview of
ADO and ADO.NET Examples and Best Practices
ADO.NET
     class names
     CLR executables
         Querying data
         returning data/messages
         SqlContext connection
         transactions
    CommandBuilder
         concurrency management
         example
     data access providers
     DataColumn objects
     DataRow objects
    DataSet objects
         overview of 2nd
         populating
         strongly typed DataSets
     DataTable objects
         DataColumns
         DataRows
         joins
         overview of 2nd
         populating DataSets with
         populating from SqlDataReader
     DataView class
     exploring with Visual Studio Object Browser
     history of 2nd
     Identity values, managing
     Multiple Active Result Sets (MARS)
     namespaces
         Imports statement
         Microsoft.SQL Server.Server
         System.Data 2nd
         System.Data.SqlClient
         System.Data.SqlTypes
    object instantiation
         constructors
         overview of
         scope
         Using block
     overview of
    populating data structures
         DataSet Load method
         DataTable Load method
         design
         hard-coding DataTable objects
         InfoMessage messages
         OUTPUT and RETURN value parameters
         overview of
         resultset elements 2nd
         SqlDataAdapter Fill method
    server-side cursors
         creating
         disadvantages of
         dynamic cursors
         fetching data from
         fetching entire cursor
         forward-only cursors
         implementing
         importance of
         keyset cursors
         managing
         opening, closing, and reopening connections
         static cursors
         updating
     SqlBulkCopy class
     SqlClient performance counters
     SQLClientFactory class
    SqlCommand class [See SqlCommand objects.]
     SqlConnection class
     SqlConnectionStringBuilder class
     SqlDataAdapter class
         Fill method
         properties
         Update method
         updates
     SqlDataReader class
     SqlDependency class
     SqlError class
     SqlErrorCollection class
     SqlException class
     SqlParameter class
     SqlParameterCollection class
     SqlTransaction class
     TableAdapter objects
Advanced Properties dialog
Advanced Services options (SQL Server)
aggregates 2nd
     CLR SUMUSD example
     definition of
     testing
aliases
     ConnectionString
     creating 2nd
AllowDelete property (DataView class)
AllowEdit property (DataView class)
AllowNew property (DataView class)
ALTER PROCEDURE statement
ampersand (&)
ANSI
     compared to Unicode
     data types
ANSI_NULLS setting
Append method
AppendFormat method
Appleman, Dan
application architectures [See architectures, choosing.]
application design [See also application architectures; architectures, choosing; DBMSs (database management systems), overview of.]
     application settings
    client/server applications
         connection pools
         definition of
     CLR executables
     concurrency
     constraints
    data access architectures
         ASP browser-based architectures
         database-agnostic applications
         multi-tiered design
         overview of
         stand-alone applications 2nd
         stand-alone applications (client/server architectures)
         XMLWeb Service architectures
    data restoration
         backup and deployment issues
         importance of
         security
     Data Sources, importing
     development costs
    example applications
         aliases, creating
         chapter-specific configuration issues
         installing
     goals of
     human element
     multi-user issues
     overview of
     population
     project specifications
     relational databases
     resource management
     scalability
     security
     SqlDataReader
     UpdateEvents application 2nd
         batch mode updates
         CustomerUpdate stored procedure
         DataRow versions
         RowUpdated event, trapping
         RowUpdating event, trapping
         Update method
     web applications
Application Name property (SQL Profiler)
ApplyDefaultSort property (DataView class)
approximate numbers
architectures
    ADO [See ADO, ADTG Recordset, accessing.]
    ADO.NET [See ADO.NET, class names.]
     choosing
     DAO (Data Access Objects)
    data access architectures
         ASP browser-based architectures
         database-agnostic applications
         multi-tiered design
         overview of
         stand-alone (client/server) applications
         XMLWeb Service architectures
     JET
     ODBC (Open Database Connectivity)
     OLEDB
     Reporting Services
     scalability
ASP browser-based architectures 2nd
assemblies, managing with Server Explorer
AsyncCallback objects
asynchronous execution of SqlCommand objects
     BeginExecuteNonQuery function
     BeginExecuteReader function
     BeginExecuteScalar function
     BeginExecuteXmlReader function
     callback 2nd
     cautions
     IAsyncResult interface
     overview of
     polling
     threads
     WaitHandle objects 2nd
AsyncState property (IAsyncResult interface)
AsyncWaitHandle property (IAsyncResult interface)
AttachDBFilename keyword
attaching
     example databases
     .MDFdatabase files
authentication (SQL Server) 2nd
authorization (SQL Server)
Auto Close option