Selecting and Updating Data from Disk-Based Tables
In this chapter, you will see details on how to retrieve data correctly and professionally in a production environment, and this chapter will lay the foundation for the more advanced T-SQL found in the forthcoming chapters. This chapter also sets the stage for selecting and updating data in in-memory tables. There are a great many similarities between disk-based and in-memory tables. You’ll learn more about in-memory tables in Chapter 13.
Up until now, you have witnessed a “lazy” method in that you have returned data from every column and every row in whatever tables you have been ...