Microsoft SQL Server 2000 Programming by Example

Cover
Que Publishing, 2001 - 771 Seiten

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.

 

Inhalt

Introduction
1
Relational Database Management Systems and SQL Server
7
Elements of TransactSQL
59
Working with Tables and Views
91
Querying and Modifying Data
121
JOINS
159
Indexes
187
Solve Join Operations
193
Using Complex Queries and Statements
463
Using Cursors
507
Transactions and Locks
553
Concurrency Problems
574
Transferring Data to and from SQL Server
617
Setting Up Linked
620
Setting
662
Servers
665

Enforcing Data Integrity
239
Programming Stored Procedures
295
Programming Triggers
329
UserDefined Functions UDF
389
A Using SQL Server Instances
703
B Using SQL Query Analyzer
721
Index
749
Urheberrecht

Häufige Begriffe und Wortgruppen

Bibliografische Informationen