1. Learn
    2. /
  2. Courses
    3. /
  3. Hierarchical and Recursive Queries in SQL Server

Exercise

Inserting and updating a table

A very important task when working with tables is inserting and updating the values in a database. The syntax for both operations is shown below.

Insert value1 and value2 into the Employee table: 

INSERT INTO Employee 
VALUES (value1, value2);

Update field1 from table Employee with value1 for the ID=1: 

UPDATE Employee 
SET field1 = value1 
WHERE ID = 1;

Your task is to insert two new values into the Person table and to update the entries of the table.

Instructions 1/2

undefined XP
    1
    2
  • Insert the new values for ID = 1 into the Person table.
  • Insert the values Peter, Jackson, 342 Flushing st, New York, and 1986-12-30 in the corresponding fields of the table.