Great! Now that you know how to add data to the database, it's time to learn how to modify existing data.
If you want to change the
Name of the user with ID 7, you can use the command:
SET Name = N'Elizabeth'
WHERE Id = 7;
User is the modified table,
Name is the modified column, and
N'Elizabeth' is the new value of the column. The
WHERE condition tells the database which rows should be modified, and it can be any condition you'd write in a
SELECT clause. (Remember that you can always go to the SQL Basics in MS SQL Server course for more information).
After you run the query, the
Name for the
Id 7 will be set to
N'Elizabeth'. Piece of cake!