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 ...
Get Beginning SQL Server 2008 Express for Developers: From Novice to Professional now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
