Book description
SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.
Table of contents
- Copyright
- About the Authors
- Acknowledgments
- Introduction
- Relational Database Management Systems and SQL Server
- Elements of Transact-SQL
- Working with Tables and Views
- Querying and Modifying Data
- Querying Multiple Tables: JOINs
-
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
-
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
- Row-Oriented Processing: Using Cursors
- Maintaining Data Consistency: Transactions and Locks
- Transferring Data to and from SQL Server
- Working with Heterogeneous Environments: Setting Up Linked Servers
- Using SQL Server Instances
- Using SQL Query Analyzer
- Index
Product information
- Title: Microsoft® SQL Server™ 2000 Programming by Example
- Author(s):
- Release date: April 2001
- Publisher(s): Que
- ISBN: 0789724499
You might also like
book
Programming Microsoft® SQL Server® 2012
Your essential guide to key programming features in Microsoft SQL Server 2012 Take your database programming …
book
Inside Microsoft® SQL Server® 2008: T-SQL Programming
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database …
book
Inside Microsoft® SQL Server® 2008: T-SQL Querying
Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside …
book
A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
“ explains the concepts and practice of data modeling with a clarity that makes the technology …