The database is now defined, has a backup and recovery plan in place, logins to the server and users to the database defined, but you have not yet had to work with any data at this point. Within this chapter, you will learn about data insertion and deletion. In Chapter 10, this will progress to retrieving and removing data.
Inserting data can be straightforward when data are simply placed into each column of a table, but in some columns you may not want to add data, such as
IDENTITY-based columns and those columns with a default value. This chapter will cover these areas, as well as show how to work with
IDENTITY values and some of the situations that can occur.
You will then move ...