In this chapter, you will learn about:
• Traditional data types
• New large value data types
• User-defined data types (including both T-SQL and CLR user-defined data types)
• 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 ...