CHAPTER 2SQL Server 2005 Database Basics

In this chapter, you will learn about:

• Tables

• Traditional data types

• New large value data types

• User-defined data types (including both T-SQL and CLR user-defined data types)

• Views

• Creating a database

• Schemas and naming conventions

Einstein argued that there must be simplified explanations of nature, because God is not capricious or arbitrary. No such faith comforts the software engineer.

—Fred Brooks in No Silver Bullet

Before we can get into the heavy topics of database development, we need to explain some of the basics for a database—things like tables, data types, and views. Tables and data types are the basics of any database. SQL Server also has views, which allow you to view any ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) 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.