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
UPDATE YourTableName
SET IsConfirmed=0
WHERE isConfirmed is Null
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With