Update
You may sometimes have to update the rows in a table. For example, in the album table, there is a row with a very long album title, and you may want to shorten it.
You don't want to delete the record - you just want to update it in place. To do this, you need to specify the album_id to ensure that only the desired row is updated and all others are not modified.
Questo esercizio fa parte del corso
Introduction to SQL Server
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Select the album
SELECT
___
FROM
___
WHERE
album_id = 213;