Beginning SQL Server 2005

Cumputers/Software. http://www.dropshippers.co.za/

If you're comfortable with Visual Basic but new to SQL Server, run to the bookstore for you, this book is a 9. - Graeme Williams, Slashdot contributor SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (nonenterprise) features from SQL Server 2005, and comes complete with development and administration tools. As such, it is an ideal database for developers and administrators to use in prototype/evaluation projects. It is also a powerful development platform for database applications on nonprofit websites, e-commerce sites, and in small offices and departments. Author Rick Dobson provides all of the installation, configuration, administration, and development techniques that you need to build applications quickly. He focuses on techniques that are easy to learn and transparent in their real-world translations. Topics include the SSMS-based query tool and T-SQL programming, and Visual Basic Express and Visual Web Developer, both with SSE, to build Windows Forms applications and to develop ASP.NET web applications. http://www.dropshippers.co.za/

• Title: Beginning SQL Server 2005 Express
• Subtitle: Database Solutions with Visual Basic Express and Visual Web Developer Express
• Illustrations note: illustrations
• Imprint name: APress
• Table of contents: Rick Dobson Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express From Novice to Professional Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express From Novice to Professional Copyright (c) 2006 by Rick Dobson All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher. ISBN (pbk): 1-59059-523-8 Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1 Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. Lead Editors: Tony Davis and Matthew Moodie Technical Reviewer: Cristian Lefter Editorial Board: Steve Anglin, Dan Appleman, Ewan Buckingham, Gary Cornell, Tony Davis, Jason Gilmore, Jonathan Hassell, Chris Mills, Dominic Shakeshaft, Jim Sumser Project Manager: Beth Christmas Copy Edit Manager: Nicole LeClerc Copy Editors: Damon Larson and Freelance Editorial Services Assistant Production Director: Kari Brooks-Copony Production Editor: Kelly Winquist Compositors: Dina Quan and Diana Van Winkle, Van Winkle Design Group Proofreader: April Eddy Indexer: Valerie Perry Cover Designer: Kurt Krames Manufacturing Director: Tom Debolski Distributed to the book trade worldwide by Springer-Verlag New York, Inc. 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders-ny@springer-sbm.com, or visit http://www.springeronline.com. For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley, CA 94710. Phone 510-549-5930, fax 510-549-5939, e-mail info@apress.com, or visit http://www.apress.com. The information in this book is distributed on an as is basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work. The source code for this book is available to readers at http://www.apress.com in the Source Code section. You will need to answer questions pertaining to this book in order to successfully download the code. Contents at a Glance About the Author. xiii About the Technical Reviewer . xv Acknowledgments. xvii Introduction . xix PART 1 - - - Working with SQL Server Express -CHAPTER 1 Getting Started with SQL Server Express . 3 -CHAPTER 2 Graphical and Command-Line Query Tools . 33 -CHAPTER 3 Exploring, Creating, and Recovering Databases . 73 -CHAPTER 4 Data Types, Tables, and Constraints . 107 -CHAPTER 5 Creating Queries from a Single Database Object . 155 -CHAPTER 6 Querying Multiple Database Objects and Manipulating Result Sets . 191 -CHAPTER 7 Leveraging Database Objects That Encapsulate T-SQL . 247 -CHAPTER 8 Managing SQL Server Express Security. 307 PART 2 - - - Working with Visual Basic Express and Visual Web Developer Express -CHAPTER 9 Introduction to Visual Basic Express and Windows Forms. 371 -CHAPTER 10 Introduction to Visual Web Developer Express, Web Pages, and Web Forms . 409 -CHAPTER 11 Programming ADO.NET . 445 -CHAPTER 12 Programming DataAdapter and DataSet Objects . 485 -CHAPTER 13 Using Visual Database and Form Design Tools . 515 -INDEX . 575 iii
http://www.dropshippers.co.za/