O'Reilly logo

Beginning SQL Server for Developers, Fourth Edition by Robin Dewson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 10

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required