Microsoft SQL Server 7.0 Programming Unleashed
Johnny Papa, Matthew Shepker, Paul D. Kimmel - Collection Unleashed
Résumé
Microsoft SQL Server 7.0 Unleashed is the most powerful resource for providing programmers with solutions to increase efficiency and improving the performance of their databases.
Table of contents
- PART I: ADVANCED PROGRAMMING TECHNIQUES
- 1: Taking Advantage of the Tools
- 2: Beyond the Basics of Data Manipulation
Language
- 3: Optimizing Queries
- 4: Advanced Transact-SQL Statements
- 5: Effective Use of Built-in Functions
- 6: Employing Cursors
- 7: Stored Procedures
- 8: Advanced String Manipulation and Bitwise
Operators
- 9: Dynatic Execution
- 10: Security Issues
- 11: Specialized Triggers
- 12: Updating Table Indexes and Statistics
- 13: Crosstabulation
- PART II: SQL SERVER - ESSENTIAL
INFORMATION
- 14: Writing Effective Code
- 15: Using Multiple Tiers and Client/Server
Architecture
- 16: Replication
- PART III: MIGRATING to SQL SERVER: DATA CONVERSION
AND INTEGRATION
- 17: Outgrowing Access
- 18: Making the Switch from Sybase SQL Server
- 19: Optimizing ODBC Using Visual C++
- 20: Connecting to SQL Server from Visual Basic
- 21: Using SQL-DMO via VB to Manage SQL Server
- 22: Automating Web Publication of SQL Server Data
- 23: SQL Server, ADO, and the Web
- 24: Microsoft's COM/DCOM
- 25: Why the Future Is Microsoft Transaction
Server
- 26: Other Development Clients and SQL Server
Connectivity
- 27: Integrating SQL with Other Microsoft Products
- 28: Scheduling Jobs and Using ActiveX Servers to
Implement Business Solutions
- 29: Programming a Line-of-Business Solution
- 30: Data Warehousing and Online Transaction Processing (OLTP)
- APPENDIXES
- A: The System Tables of the Master Database
- B: The System Tables of All Databases
- C: Common Error Messages
- INDEX
L'auteur - Johnny Papa
, MCP, MCT and MCSD, is a trainer and a developer with Blue Sand Software, Inc in Raleigh, NC. He contributes articles to Visual Basic Programmer's Journal and Microsoft Interactive Developer (MIND).
L'auteur - Matthew Shepker
,is the director of Technology and Development for Diversified Consulting Resources, Inc., in Overland Park, Kansas. He is a Microsoft Certified Systems Engineer and a Microsoft Certified Trainer holding 11 certifications. Matthew is currently working on completing the Microsoft Certified Database Administrator and Microsoft Certified Solutions Developer certifications. Matthew has been working with SQL Server for more than four years in a variety of business applications including online transaction processing, decision support systems, and other custom software.
Matthew has authored one other book, New Riders's MCSE Core NT Exams, and has co-authored five other books, including Sams's Microsoft SQL Server 7.0 Programming Unleashed and Que's Using SQL Server 7.0.
L'auteur - Paul D. Kimmel
Paul D. Kimmel, PhD, CPA, received his bachelor's degree from the University of Minnesota and his doctorate in accounting from the University of Wisconsin. He is an Associate Professor at the University of Wisconsin-Milwaukee, and has public accounting experience with Deloitte & Touche (Minneapolis). He was the recipient of the UWM School of Business Advisory Council Teaching Award, the Reggie Taite Excellence in Teaching Award, and a three-time winner of the Outstanding Teaching Assistant Award at the University of Wisconsin. He is also a recipient of the Elijah Watts Sells Award for Honorary Distinction for his results on the CPA exam. He is a member of the American Accounting Association and has published articles in Accounting Review, Accounting Horizons, Advances in Management Accounting, Managerial Finance, Issues in Accounting Education, Journal of Accounting Education, as well as other journals.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Sams |
Auteur(s) | Johnny Papa, Matthew Shepker, Paul D. Kimmel |
Collection | Unleashed |
Parution | 17/07/1999 |
Nb. de pages | 946 |
Format | 17,8 x 23,2 |
EAN13 | 9780672312939 |
Avantages Eyrolles.com
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