Beginning SQL Server 2000 for Visual Basic Developers

Thearon Willis (Autor)

Buch | Softcover

880 Seiten

2003 | Softcover reprint of the original 1st ed.
Apress (Verlag)
978-1-59059-273-1 (ISBN)

Artikel merken

This is the only book that provides comprehensive coverage of SQL Server 2000 specifically from a Visual Basic programmer's point of view. SQL Server is now the first choice for the Visual Basic developer who wants a more powerful, reliable, and sophisticated database than Microsoft Access can provide. SQL Server 2000 is tightly integrated with Windows 2000, offering more support for XML and much improved Online Analytical Processing (OLAP) services.

This book is for Visual Basic developers who want to integrate SQL Server 2000 into their applications. It covers everything you need to know to work with SQL Server 2000 and provide users of your Visual Basic and web-based applications with controlled access to your data. You'll start with an introduction to designing and creating a database and then move on to create increasingly complex T-SQL stored procedures. Throughout, you'll learn how to incorporate data access (including ADO) into your Visual Basic applications, manage security, and make data available across the Web.

Thearon Willis is a senior consultant with 19 years of IT experience. He is a consultant for an international insurance company that provides web programming services. His web development tools of choice are ASP, dynamic HTML, Visual Basic, and SQL Server.

Introduction to SQL Server 2000; Installing the Personal Edition of SQL Server 2000; Designing and Creating the Development Database; SQL Server Security; SQL Server Query Analyzer; Database Connections; Introduction to Stored Procedures; Stored Procedures versus SQL Statements; Selecting Data; Inserting Data; Updating Data; Deleting Data; Working with Text Data; Installing Internet Information Server (IIS); SQL Server and XML; XML 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.

Zusatzinfo	X, 880 p.
Verlagsort	Berkley
Sprache	englisch
Maße	178 x 235 mm
Themenwelt	Informatik ► Datenbanken ► SQL Server
	Informatik ► Programmiersprachen / -werkzeuge ► Visual Basic
	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	1-59059-273-5 / 1590592735
ISBN-13	978-1-59059-273-1 / 9781590592731
Zustand	Neuware