Answers for "sql statement update null values"

SQL
1

can you update NULL in sql

UPDATE [table]
SET [column]=0
WHERE [column] IS NULL;
Posted by: Guest on February-19-2021
0

how to replace null values in sql

--See records where specific column is NULL
SELECT * from table1 WHERE column1 ISNULL 

--Update all the NULL values in the selected column
UPDATE table1 SET column1 = replace_value WHERE column1 ISNULL
Posted by: Guest on June-14-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language