+612 9045 4394
$7.95 Delivery per order to Australia and New Zealand
100% Australian owned
Over a hundred thousand in-stock titles ready to ship
Beginning SQL Server 2000 for Visual Basic Developers : Ex Peer - Thearon Willis

Beginning SQL Server 2000 for Visual Basic Developers

Ex Peer

Paperback Published: 2nd September 2003
ISBN: 9781590592731
Number Of Pages: 880

Share This Book:


RRP $59.99
Ships in 10 to 15 business days

Earn 101 Qantas Points
on this Book

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 wanting a more powerful, reliable and sophisticated database than MS Access can provide. SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services. This book is for VB developers who want to integrate SQL Server 2000 into their applications. It covers everything needed to work with SQL Server 2000, including topics such as SQL Server 2000 tools, managing database security, building and deploying English query applications, and more. The Jet database engine, which has traditionally powered Access, is gradually being replaced by the Microsoft Database Engine (MSDE), a limited-client version of the SQL Server engine (but without the front-end tools such as Enterprise Manager). This means that VB developers traditionally used to using a single-file database now have to cope with the client-server architecture of SQL Server. This is a big conceptual leap, and many VB developers struggle to make it. This book is designed to help developers make that leap as easily as possible, and to show them how to use the full range of SQL Server's powerful tools within their VB applications.

Introductionp. 1
Introduction to SQL Server 2000p. 11
Installing the Personal Edition of SQL Server 2000p. 31
Designing and Creating the Development Databasep. 65
SQL Server Securityp. 101
SQL Server Query Analyzerp. 127
Database Connectionsp. 167
Introduction to Stored Proceduresp. 201
Stored Procedures versus SQL Statementsp. 253
Selecting Datap. 295
Inserting Datap. 353
Updating Datap. 403
Deleting Datap. 451
Working with Text Datap. 485
Installing Internet Information Server (IIS)p. 539
SQL Server and XMLp. 563
XML Web Reportsp. 605
Building an English Query Applicationp. 663
Deploying an English Query Applicationp. 713
SQL Server and VB Data Typesp. 751
ADO 2.6 Object Modelp. 755
SQL Server Functionsp. 771
Building the Hardware Tracking Frameworkp. 803
Creating the Hardware Tracking Business Server Componentp. 819
App. F: Referencesp. 831
Support, Errata, and forums.apress.comp. 835
Indexp. 845
Table of Contents provided by Blackwell. All Rights Reserved.

ISBN: 9781590592731
ISBN-10: 1590592735
Series: Ex Peer
Audience: General
Format: Paperback
Language: English
Number Of Pages: 880
Published: 2nd September 2003
Country of Publication: US
Dimensions (cm): 22.86 x 18.49  x 4.57
Weight (kg): 1.37
Edition Type: Revised

Earn 101 Qantas Points
on this Book