Yurttas/PL/DBL/mssql/F/01/SPJ/q08.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM q08.sql
 4REM
 5REM Change the color of part 'P02' to 'Yellow',
 6REM increase its weight by 5, and
 7REM set its city to unknown('NULL').
 8REM
 9*/
10
11UPDATE Parts
12SET color='Yellow',
13    weight=weight+5,
14    city='NULL'
15WHERE pn = 'P02';