Beginning SQL server 2000 for visual basic developers

Thearon Willis

880 pages, parution le 15/02/2001

Ajouter à une liste

Indisponible

Résumé

SQL Server 2000 is a feature-rich and robust enterprise-level database application, which many VB programmers choose to, provide the data layer in their n-tier applications.

This book covers A you need to know to work with SQL Server 2000, to provide users of your VB and web-based applications with controlled access to your data.

creating increasingly complex T-SQL stored procedures, you'll learn how to incorporate data access (including ADO) into your VB applications, manage security, and make data available across the Web.

Comprehensively explained step-by-step examples will guide you through creating an entire VB-based application to, manage both the data itself and access to that data. Additionally, you will learn how to create and deploy web reports and an English Query application.

Who is this book for?

This book is for VB developers who want to, integrate SQL Server 2000 into their applications. No previous knowledge of SQL Server is assumed.

What does this book cover? Introduction to relational database design and theory Installing the Personal Edition of SQL Server 2000 SQL Server 2000 tools T-SQL syntax for queries and stored procedures How to create and run stored procedures from VB applications and components

Managing database security

o XML features of SQL Server 2000

o Producing formatted XML web reports using XSL

o Building and deploying English Query applications

Summary of Contents

Introduction
Chapter 1: Introduction to SQL Server 2000
Chapter 2: Installing the Personal Edition of SQL Server 2000
Chapter 3: Designing and Creating the Development Database
Chapter 4: SQL Server Security
Chapter 5: SQL Server Query Analyzer
Chapter 6: Database Connections
Chapter 7: Introduction to Stored Procedures
Chapter 8: Stored Procedures versus SQL Statements
Chapter 9: Selecting Data
Chapter 10: Inserting Data
Chapter 11: Updating Data
Chapter 12: Deleting Data
Chapter 13: Working with Text Data
Chapter 14: Installing Internet Information Server (IIS)
Chapter 15: SQL Server and XIVIL
Chapter 16: XIVIL Web Reports
Case Study: Part 1 - Building an English Query Application
Case Study: Part 2 - Deploying an English Query Application
Appendix A: SQL Server and VB Data Types
Appendix B: ADO 2.6 Object Model
Appendix C: SQL Server Functions
Appendix D: Building the Hardware Tracking Framework
Appendix E: Creating the Hardware Tracking Business Server Component
Appendix F: References
Appendix G; Support, Errata, and P2P.wrox.com
Index

L'auteur - Thearon Willis

Thearon Willis - Thearon Willis is a senior consultant with 19 years of IT experience. He is currently a consultant for an International Insurance company, which provides Web programming services. His Web development tools of choice are ASP, Dynamic HTML, Visual Basic and SQL Server.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Thearon Willis
Parution	15/02/2001
Nb. de pages	880
Format	18,4 x 23,2
Couverture	Broché
Poids	1417g
Intérieur	Noir et Blanc
EAN13	9781861004673