Learn how to turn data into solutions with SQL Server
2000, Visual Basic .NET, and XML.
Find out the fastest ways to transform data into potent
business solutions with this definitive guide for
developers. You'll get a fundamental grasp of SQL
Server™ programming techniques for data access, data
manipulation, and data definition with T-SQL, and you'll
learn how to make the most of the language enhancements in
Visual Basic® .NET, the programming advances in the
Microsoft® Visual Studio® .NET integrated development
environment, and the state-of-the-art technologies of the
.NET framework, including ADO.NET, ASP.NET, and XML Web
services. You also get in-depth coverage of SQL Server
database security management, SQL Server Web releases, and
features for interoperability between ADO.NET and XML. If
you're looking for expert insights on how to build
powerful, secure solutions with SQL Server 2000 and Visual
Basic .NET, this is the book for you. Coverage includes
these topics:
• XML Web services
• SQL Server 2000 XML functionality
• XML data-processing techniques
• Class, event, and error-processing innovations
• Tables and data types
• Programming data access with T-SQL
• Programming views and stored procedures
• Programming user-defined functions and
triggers
• SQL Server 2000 security
• Creating Microsoft Windows®–based applications
with SQL Server 2000 and Visual Basic .NET
• Programming Windows solutions with ADO.NET
• Programming ASP.NET solutions
CD-ROM FEATURES:
• A fully searchable electronic copy of the book
• Sample code written in Visual Basic .NET and
T-SQL
Contents
- 1 Getting Started with Visual Basic .NET for SQL Server
2000
- 2 Tables and Data Types
- 3 Programming Data Access with T-SQL
- 4 Programming Views and Stored Procedures
- 5 Programming User-Defined Functions and Triggers
- 6 SQL Server 2000 XML Functionality
- 7 SQL Server 2000 Security
- 8 Overview of the .NET Framework
- 9 Creating Windows Applications
- 10 Programming Windows Solutions with ADO.NET
- 11 Programming ASP.NET Solutions
- 12 Managing XML with Visual Basic .NET
- 13 Creating Solutions with XML Web Services