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
4. The AdoptivePerson table

Instruction

Now we have the last table, AdoptivePerson. It stores information about people who pay for the care of certain animals at the zoo.

Exercise

Select all the information from the AdoptivePerson table. You'll find the following columns:

  • Id—uniquely identifies each adoptive person in the database.
  • FirstName—the first name of the adoptive person.
  • LastName—the last name of the adoptive person.
  • City—the city where this person lives.
  • AnimalId—refers to the Animal table and shows which animal this person has donated money for.