Microsoft SQL Server 2000 Programming by ExampleQue 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 |
749 | |