Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition

CHAPTER
7	Modification of a Table’s Contents

In This Chapter

•   INSERT Statement

•   UPDATE Statement

•   DELETE Statement

•   Other T-SQL Modification Statements and Clauses

In addition to the SELECT statement, which was introduced in Chapter 6, there are three other DML statements: INSERT, UPDATE, and DELETE. Like the SELECT statement, these three modification statements operate either on tables or on views. This chapter discusses these statements in relation to tables and gives examples of their use. Additionally, it explains two other statements: TRUNCATE TABLE and MERGE. Whereas the TRUNCATE TABLE statement is a Transact-SQL extension to the SQL standard, MERGE is a standardized feature. The chapter wraps up with coverage of the ...