search for books and compare prices
Tables of Contents for Microsoft SQL Server 7.0 Programming
Chapter/Section Title
Page #
Page Count
Introduction
1
4
PART I ADVANCED PROGRAMMING TECHNIQUES
5
358
Taking Advantage of the Tools
7
14
Beyond the Basics of Data Manipulation Language
21
36
Optimizing Queries
57
34
Advanced Transact-SQL Statements
91
32
Effective Use of Built-in Functions
123
28
Employing Cursors
151
26
Stored Procedures
177
28
Advanced String Manipulation and Bitwise Operators
205
22
Dynamic Execution
227
24
Security Issues
251
22
Specialized Triggers
273
32
Updating Table Indexes and Statistics
305
28
Crosstabulation
333
30
PART II SQL SERVER-ESSENTIAL INFORMATION
363
78
Writing Effective Code
365
26
Using Multiple Tiers and Client/Server Architecture
391
26
Replication
417
24
PART III MIGRATING TO SQL SERVER: DATA CONVERSION AND INTEGRATION
441
478
Outgrowing Access
443
20
Making the Switch from Sybase SQL Server
463
22
Optimizing ODBC Using Visual C++
485
78
Connecting to SQL Server from Visual Basic
563
42
Using SQL-DMO via VB to Manage SQL Server
605
28
Automating Web Publication of SQL Server Data
633
28
SQL Server, ADO, and the Web
661
24
Microsoft's COM/DCOM
685
28
Why the Future Is Microsoft Transaction Server
713
18
Other Development Clients and SQL Server Connectivity
731
30
Integrating SQL with Other Microsoft Products
761
20
Scheduling Jobs and Using ActiveX Servers to Implement Business Solutions
781
12
Programming a Line-of-Business Solution
793
12
Data Warehousing and Online Transaction Processing (OLTP)
805
114
APPENDIXES
A The System Tables of the Master Database
857
18
B The System Tables of All Databases
875
24
C Common Error Messages
899
20
Index
919