December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Summary
This chapter covers the basic tools you can use to ensure the integrity of the data in a database. The integrity of data is directly related to its value; remember the concept of “garbage in, garbage out.” If you take the time to implement the constraints and other methods discussed in this chapter, you provide a solid foundation for the storage of data and avoid the headaches related to dealing with “garbage” data.
Chapter 23, “Creating and Managing Views,” discusses a means for virtually accessing the data in tables. Virtual tables, or views, allow you to selectively choose the data elements on one or more tables that you want to present as a single window into your data.