Problem solve Get help with specific problems with your technologies, process and projects.

Book excerpt: Retrieve data from a SQL Server 2005 table

There's much to learn about SQL Server 2005 development. This chapter excerpt covers a basic but essential task -- getting an application to retrieve data from a table.

Murach is calling SQL Server 2005 for Developers "the SQL book that most developers don't even know they need." Why? There are plenty of SQL Server 2005 features of interest to developers, such as the ability to create database objects using Visual Basic and the option to work with XML data. SQL Server 2005 for Developers covers those two topics, and it offers some hints for juggling various data types, database design and

Chapter 3,  How to retrieve data from a single table, introduces the SELECT statement, which is used to get data from one or more tables. The authors discuss how to use SELECT statements to perform seven common operations, from coding column specifications to returning a subset of selected rows. The authors also offer tips for working with the WHERE clause, which acts as a filter for rows in a base table, and the ORDER BY clause, which specifies the sort order for the rows in a result set.

Read the excerpt in this PDF.


Excerpted from Murach's SQL Server 2005 for Developers (ISBN 978-1-890774-39-4) by Bryan Syverson and Joel Murach.
Copyright © 2007. Published by Mike Murach & Associates Inc.. Reprinted with permission.

Dig Deeper on SQL Server and .NET development

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.