TSQL: update column to zero

Question

The student is here. It should be esasy, but I can't figure it out.

I have a table like this:

ID -- NAME -- CHOICE 1 -- John -- book 2 -- Matt -- pen 3 -- Linda -- bag . . 

What will be the script to turn all the data in the CHOICE column to null?

Thanks a ton

Answer 1

You should use the UPDATE statement without a WHERE clause (so it updates every row)

 UPDATE YourTable SET Choice = NULL