Publisher's Synopsis
How to leverage SQL Server 7′s powerful new features to build sophisticated client/server and intranet applications Building Microsoft(r) SQL Server(r) 7 Applications with COM This book helps you to quickly master all the latest features of SQL Server 7′s revised architecture. It also provides you with a complete, step–by–step tutorial on creating n–tier client/server and intranet applications using SQL Server 7 with COM objects and MTS. Expert Sanjiv Purba walks you through each stage of development–from planning, database design, and prototyping, to coding, testing, and reporting–providing sample code (and resulting output) for the techniques described. Key topics receiving in–depth, practical coverage include:
∗ SQL 7 design and architecture
∗ COM and MTS architectures
∗ SQL 7 installation–covered in a quick–reference installation guide
∗ Database objects, data functions, formats and other critical new SQL features
∗ Server–side database programming with stored procedures, triggers, views, and other techniques
∗ Developing n–tier applications with COM, MTS, and ASP
∗ Leveraging Transact SQL in developing n–tier applications
∗ N–tier implementation guidelines
∗ Database roles and responsibilities on a project
∗ Systems management
Wiley Computer Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/