Beginning SQL Server 2000 for Visual Basic Developers
Everywhere you look these days Microsoft SQL Server is there. You hear about dotcom companies running SQL Server and accessing terabytes of data, and applications that need to be scaled up from Access to use SQL Server. You just can't seem to escape the presence of SQL Server in the workplace. SQL Server 2000 is the latest release and, because of performance enhancements and new features, this is a great time to learn how to use SQL Server and how to incorporate it into your applications. Whether you are building VB applications (front-end or back-end) or web applications, if you need data access to SQL Server 2000 this book can help. While most of the book covers accessing SQL Server 2000 from VB, the same principles can be applied to Active Server Pages using VBScript and ADO (Active X Data Objects). This book covers the use of in-line SQL statements and stored procedures, and how to use both in your VB programs and web applications. The new XML features of SQL Server 2000 are also covered - you will learn how to execute queries and stored procedures in the URL of a web browser to retrieve XML data from the database. XML templates, XSL stylesheets, and XML schemas are also covered, and we show you how to format your XML data into a presentable format for display in a browser.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Introduction to SQL Server 2000
Inserting Data Chapter 11 Updating Data
28 other sections not shown
Other editions - View all
allows CD_T chapter checkbox choose combo box Command object component Connection object contains data type Declare default defined delete dialog display element employee Employee_T table Enterprise Manager entity error handling Exit First_Name_VC foreign key function Hardware Users Hardware_T table in-line SQL statements installed instance of SQL keyword Location_T login menu item Microsoft Microsoft SQL Server Null objCmd.Parameters.Append ODBC OK button OLE DB option Parameters collection password permissions primary key Query Analyzer Query icon query window Recordset object referential integrity relationship return code return value row of data select data SELECT statement set a reference software title Software_T specified SQL Server 2000 SQL Server authentication stored procedure strError string strMessage System Assignment T-SQL template toolbar transaction log update valid variable virtual directory Windows NT 4.0 Wizard XML data XSL stylesheet