O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

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 4. Querying and Modifying Data

In Chapter 2, "Elements of Transact-SQL," you learned the basics of all the statements that make up the Data Manipulation Language (DML), which are used to interact with the information stored in the database. Moreover, these four elements of the DML (SELECT, INSERT, UPDATE, and DELETE ) are the core of database programming.

This chapter teaches you the following:

  • The components and syntax of the SELECT statement

  • How to insert data in the database using the INSERT statement

  • How to create a table and populate it on-the-fly from result sets

  • How to modify data through the UPDATE statement

  • How the data is removed using the DELETE statement

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