• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Mastering T-SQL > Modifying Data with Action Queries

Modifying Data with Action Queries

The queries that we have explored thus far are all SELECT queries. This means that they select data from one or more tables. The queries that we will discuss now are action queries. They are queries that modify data. The five types of action queries that we will discuss are INSERT, UPDATE, SELECT INTO, DELETE, and TRUNCATE.

The INSERT Statement

You use the INSERT statement to insert data into an existing table. The INSERT statement has the following format:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint