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
7. Exercise 3

Instruction

Good job! Let's keep going.

Exercise

A mistake has crept into the database. The adoptive person Gary Thomas (Id = 3) has the FirstName value N'Thomas' and the LastName value N'Gary'.

Correct this and print the previous last name (name the column LastNameBefore) and the updated last name (name the column LastNameAfter). Use an UPDATE operation.
Recall that the name of the relevant table is AdoptivePerson.