Set false in specific column to all rows

sql-server, t-sql

Solution

UPDATE YourTableName
SET IsConfirmed=0
WHERE isConfirmed is Null

Problem

I have a table with the following columns: ``` ID Name 1 test1 2 test2 ``` Now I added new column `IsConfirmed`. And this column contain `null` in all rows. ``` ID Name IsConfirmed 1 test1 null 2 test2 null ``` How can I set `false` to `IsConfirmed` column to all rows in the table using T-SQL? Thanks

Original source