O'Reilly logo

Beginning SQL Server 2008 Express for Developers: From Novice to Professional by Robin Dewson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Selecting, Updating, and Deleting Data

In this chapter, you will see more details on how to retrieve data correctly and professionally in a production environment. Up until now, we have been using a "lazy" method in that we have returned data from every column and every row in whatever tables we've been querying. This chapter will detail why that is not ideal, and it will demonstrate the correct methods. You will also see how to change column headings so that they provide more meaningful names for non-IT people. Then you will see how to reduce the data brought back by filtering for only the rows you want. The final sections in this chapter on retrieving data will introduce you to some basic string functions, how to order the data, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required