Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by Carlos Eduardo Rojas, Fernando G. Guerrero
Microsoft® SQL Server™ 2000 Programming by Example
Copyright
About the Authors
Acknowledgments
Introduction
Relational Database Management Systems and SQL Server
Database Models
A Brief History of SQL Server
Basics of SQL Server Architecture
Client/Server Applications Design
Elements of Transact-SQL
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Data Types
Additional Elements
Programming Scripts and Batches
Working with Tables and Views
Creating and Altering Tables
Creating and Altering Views
Querying and Modifying Data
Querying Data
Modifying Data
Querying Multiple Tables: JOINs
ANSI SQL-92 Syntax
INNER JOIN
OUTER JOINs
CROSS JOINs
Self Joins
The UNION Operator
Optimizing Access to Data: Indexes
Introduction to Indexes
Benefits of Indexes
How to Create Indexes
How SQL Server 2000 Stores Data
How SQL Server 2000 Modifies Data
Index Enhancements in SQL Server 2000
Accessing Data Without Indexes: Table Scan
Types of Indexes
Covered Queries and Index Intersection
Index Maintenance
Indexes on Computed Columns
Indexed Views
Index Tuning Wizard
Summary
Enforcing Data Integrity
Types of Data Integrity
Enforcing Integrity: Constraints (Declarative Data Integrity)
Implementing Business Logic: Programming Stored Procedures
Benefits of Using Stored Procedures
Types of Stored Procedures
Creating and Dropping Stored Procedures
Using Parameters
Altering Stored Procedure Definitions
The RETURN Statement
Executing Stored Procedures
Stored Procedure Recompilation
Handling Errors
Nesting Stored Procedures
Application Security Using Stored Procedures
Implementing Complex Processing Logic: Programming Triggers
Benefits of Triggers
Trigger Enhancements in SQL Server 2000
Inserted and Deleted Tables
Types of Triggers According to Their Order
Creating and Dropping Triggers
Altering Trigger Definitions
Disabling Triggers
Nesting Triggers
Recursive Triggers
Security Implications of Using Triggers
Enforcing Business Rules: Choosing Among INSTEAD of Triggers, Constraints, and AFTER Triggers
Enhancing Business Logic: User-Defined Functions (UDF)
Benefits of User-Defined Functions
Built-In User-Defined Functions
Types of User-Defined Functions According to Their Return Value
Dropping User-Defined Functions
Preventing the Alteration of Dependent Objects:The SCHEMABINDING Option
Deterministic and Nondeterministic Functions
Altering User-Defined Functions Definition
Security Implications of Using User-Defined Functions
Applying User-Defined Functions
Using Complex Queries and Statements
Subqueries
Correlated Subqueries
Derived Tables
The CASE Function
The COMPUTE Clause
The CUBE and ROLLUP Operators
Using Hints
Row-Oriented Processing: Using Cursors
Row-by-Row Versus Set-Oriented Processing
Types of Cursors
Steps to Use Cursors
Scope of Cursors
Using Cursors to Solve Multirow Actions in Triggers
Application Cursors
Maintaining Data Consistency: Transactions and Locks
Characteristics of Transactions (ACID)
Using Transactions
Concurrency Problems
Isolation Levels
Types of Locks
A Serious Problem to Avoid: Deadlocks
Transferring Data to and from SQL Server
The Need for Transferring Data
Tools for Transferring Data Using SQL Server 2000
The BULK INSERT Statement and bcp
Using Data Transformation Services
The Copy Database Wizard
Working with Heterogeneous Environments: Setting Up Linked Servers
Distributed Queries
Distributed Transactions
Using SQL Server Instances
Installing SQL Server Instances
Connecting to Instances
System Functions Used in Multi-Instance Installations
Current Limitations
Using SQL Query Analyzer
Installing SQL Query Analyzer
The Query Analyzer Workplace
Managing User and Connection Options
Defining and Using Templates for Query Analyzer
Analyzing Queries
Working with the Transact-SQL Debugger
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Summary
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset