Data Insertion, Deletion, and Transactions—Disk-Based
The database is now defined, has a backup and recovery plan in place, and logins to the server and users to the database are 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 12, this will progress to retrieving and removing data.
Inserting data can be straightforward when data is 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 ...