Here's how to modify data in a table. At the end of each command press the space-bar or press enter before continuing the next step. Type update Type the name of the table you are updating. Type set Type the name of the column that you want to change the data in. Type where Type the name of the column you are changing the data in.
Type go and press Enter.
If you see Msg 207, Level 16, State 2 Server '', Line 1 Invalid column name 'name'.