SQL Server 2000™ Programming by Example
Fernando G. Guerrero, Carlos Eduardo Rojas
771 pages, parution le 01/05/2001
Résumé
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.
Get up to speed on SQL Server 2000 and how to take full advantage of new features.
Contents
- Introduction
- 1 Relational Database Management Systems and SQL Server
- 2 Elements of Transact-SQL
- 3 Working with Tables and Views
- 4 Querying and Modifying Data
- 5 Querying Multiple Tables: JOINS
- 6 Optimizing Access to Data: Indexes
- 7 Enforcing Data Integrity
- 8 Implementing Business Logic: Programming Stored Procedures
- 9 Implementing Complex Processing Logic: Programming Triggers
- 10 Enhancing Business Logic: User-Defined Functions (UDF)
- 11 Using Complex Queries and Statements
- 12 Row-Oriented Processing: Using Cursors
- 13 Maintaining Data Consistency: Transactions and Locks
- 14 Transferring Data to and from SQL Server
- 15 Working with Heterogeneous Environments: Setting Up Linked Servers
- A Using SQL Server Instances
- B Using SQL Query Analyzer
- Index
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Que |
| Auteur(s) | Fernando G. Guerrero, Carlos Eduardo Rojas |
| Parution | 01/05/2001 |
| Nb. de pages | 771 |
| Format | 18,7 x 23,3 |
| Couverture | Broché |
| Poids | 1320g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780789724496 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
