List of Tables

Chapter 2: Introduction to Databases

Table 2.1: SOME ROWS FROM THE PRODUCTS TABLE

Table 2.2: MEANING OF THE AVAILABLE PERMISSIONS

Table 2.3: SQL SERVER DATABASE TYPES

Table 2.4: DEFINITION FOR THE COLUMNS OF THE Customers TABLE

Table 2.5: DEFINITION FOR THE COLUMNS OF THE Orders TABLE

Table 2.6: DEFINITION FOR THE COLUMNS OF THE Order Details TABLE

Table 2.7: DEFINITION FOR THE COLUMNS OF THE Products TABLE

Table 2.8: DEFINITION FOR THE COLUMNS OF THE Persons TABLE

Chapter 3: Introduction to Structured Query Language (SQL)

Table 3.1: SQL MATHEMATICAL OPERATORS

Table 3.2: WILDCARD CHARACTERS

Table 3.3: LOGICAL OPERATORS

Chapter 4: Introduction to Transact-SQL Programming

Table 4.1: RETURN VALUES FROM THE @@FETCH_STATUS FUNCTION

Table 4.2: FUNCTIONS

Table 4.3: AGGREGATE FUNCTIONS

Table 4.4: MATHEMATICAL FUNCTIONS

Table 4.5: STRING FUNCTIONS

Table 4.6: DATE AND TIME FUNCTIONS

Table 4.7: SYSTEM FUNCTIONS

Table 4.8: ROW ADDED TO THE ProductAudit TABLE BY InsertProductTrigger

Table 4.9: ROW ADDED TO THE ProductAudit TABLE BY UpdateUnitPriceProductTrigger

Table 4.10: ROW ADDED TO THE ProductAudit TABLE BY DeleteProductTrigger

Chapter 6: Introducing Windows Applications and ADO.NET

Table 6.1: ACCESS MODIFIERS

Table 6.2: COMMONLY USED WINDOWS FORM CONTROLS

Chapter 7: Connecting to a Database

Table 7.1: SqlConnection PROPERTIES

Table 7.2: SqlConnection METHODS

Table 7.3: SqlConnection EVENTS

Table 7.4: ConnectionState CONSTANTS

Chapter 8: Executing Database Commands

Table 8.1: SqlCommand PROPERTIES

Table 8.2: SqlCommand METHODS

Table 8.3: CommandType ENUMERATION VALUES

Table 8.4: METHODS THAT RETRIEVE INFORMATION FROM THE DATABASE

Table 8.5: CommandBehavior ENUMERATION VALUES

Table 8.6: SCHEMA COLUMN VALUES

Table 8.7: FOR XML KEYWORDS

Table 8.8: THE ExecuteNonQuery() METHOD

Table 8.9: SqlDbType ENUMERATION MEMBERS

Chapter 9: Using DataReader Objects to Read Results

Table 9.1: SqlDataReader PROPERTIES

Table 9.2: SqlDataReader METHODS

Table 9.3: STANDARD C# AND .NET TYPES

Table 9.4: SQL SERVER TYPES, COMPATIBLE STANDARD C# TYPES, AND GET* METHODS

Table 9.5: Products TABLE COLUMNS, TYPES, AND METHODS

Table 9.6: Sql* TYPES

Table 9.7: SQL SERVER TYPES, COMPATIBLE Sql* TYPES, AND GetSql* METHODS

Table 9.8: Products TABLE COLUMNS, TYPES, AND GetSql* METHODS

Chapter 10: Using Dataset Objects to Store Data

Table 10.1: SqlDataAdapter PROPERTIES

Table 10.2: SqlDataAdapter METHODS

Table 10.3: SqlDataAdapter EVENTS

Table 10.4: DataSet PROPERTIES

Table 10.5: DataSet METHODS

Table 10.6: DataSet EVENT

Table 10.7: MissingSchemaAction ENUMERATION MEMBERS

Table 10.8: XmlWriteMode ENUMERATION MEMBERS

Table 10.9: XmlReadMode ENUMERATION MEMBERS

Chapter 11: Using DataSet Objects to Modify Data

Table 11.1: DataTable PROPERTIES

Table 11.2: DataTable METHODS

Table 11.3: DataTable EVENTS

Table 11.4: DataRow PROPERTIES

Table 11.5: DataRow METHODS

Table 11.6: DataColumn PROPERTIES

Table 11.7: SchemaType ENUMERATION MEMBERS

Table 11.8: DataViewRowState ENUMERATION MEMBERS

Table 11.9: DataRowVersion ENUMERATION MEMBERS

Table 11.10: DataRowState ENUMERATION MEMBERS

Table 11.11: SqlDataAdapter EVENTS

Table 11.12: FillErrorEventArgs PROPERTIES

Table 11.13: SqlRowUpdatingEventArgs PROPERTIES

Table 11.14: ADDITIONAL SqlRowUpdatedEventArgs PROPERTY

Table 11.15: DataTable EVENTS

Table 11.16: DataColumnChangeEventArgs PROPERTIES

Table 11.17: DataRowChangeEventArgs PROPERTIES

Chapter 12: Navigating and Modifying Related Data

Table 12.1: UniqueConstraint PROPERTIES

Table 12.2: ForeignKeyConstraint PROPERTIES

Table 12.3: DataRelation PROPERTIES

Table 12.4: Rule ENUMERATION MEMBERS

Chapter 13: Using DataView Objects

Table 13.1: DataView PROPERTIES

Table 13.2: DataView METHODS

Table 13.3: DataViewRowState ENUMERATION MEMBERS

Table 13.4: DataRowView PROPERTIES

Table 13.5: DataRowView METHODS

Table 13.6: DataViewManager PROPERTIES

Chapter 14: Advanced Transaction Control

Table 14.1: SqlTransaction PROPERTIES

Table 14.2: SqlTransaction METHODS

Table 14.3: SQL Standard Isolation Levels

Table 14.4: IsolationLevel Enumeration Members

Table 14.5: SQL Server Lock Types

Table 14.6: SQL Server Locking Modes

Chapter 15: Introducing Web Applications-ASP.NET

Table 15.1: WEB FORM CONTROLS

Table 15.2: Label CONTROLS

Table 15.3: RadioButtonList ITEMS

Table 15.4: DropDownList ITEMS

Chapter 16: Using SQL Server's XML Support

Table 16.1: FOR XML KEYWORDS

Table 16.2: DIRECTIVES

Table 16.3: SPECIFYING THE CONTEXT

Table 16.4: SPECIAL CHARACTERS IN A SQL STATEMENT AND THEIR REPLACEMENTS IN A URL

Table 16.5: XmlDocument Properties

Table 16.6: XmlDocument Methods

Table 16.7: XmlDocument Events

Table 16.8: XmlDataDocument Methods