The SQL Server Transact-SQL language has a set of DML statements that you can use to manipulate table data. In this chapter, you learned how to add data to a table using the INSERT
statement, how to delete the data using the DELETE
statement, and how to update existing data using the UPDATE
statement. You learned about the MERGE
statement and how you can use it to avoid multiple INSERT
, UPDATE
, and DELETE
DML statements. You also learned how to use the TRUNCATE TABLE
and SELECT…INTO
statements.
SQL Server 2014 Development Essentials
By :
SQL Server 2014 Development Essentials
By:
Overview of this book
Table of Contents (14 chapters)
SQL Server 2014 Development Essentials
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Microsoft SQL Server Database Design Principles
Understanding DDL and DCL Statements in SQL Server
Data Retrieval Using Transact-SQL Statements
Data Modification with SQL Server Transact-SQL Statements
Understanding Advanced Database Programming Objects and Error Handling
Performance Basics
Index
Customer Reviews