Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Insert, Update, or Delete Data in MS SQL Server

Quiz
3. The Employee table

Instruction

The second table, Employee, contains data about people working at the zoo.

Exercise

Select all the data from the Employee table. It contains the following columns:

  • Id—a unique identifier for each employee.
  • FirstName—the employee's first name.
  • MiddleName—the employee's middle name; if they don't have a middle name, this field will store NULL.
  • LastName—the employee's last name.
  • Age—the employee's age.