CHAPTER 11
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 ...
Get Beginning SQL Server for Developers, Fourth Edition 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.
