SQL Upsert

sathish

From the below table how to update the item column to null for all rows using merge update statement

ID	Product	Items
1	Product1	2
2	Product2	2
3	Product3	2
4	Product4	1
5	Product5	1

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tahir Ansari3y ago

Accepted answer

MERGE INTO YourTable AS Target
USING (
    SELECT ID
    FROM YourTable
) AS Source
ON (Target.ID = Source.ID)
WHEN MATCHED THEN
    UPDATE SET Target.Items = NULL;

Saravanan Ganesan3y ago
You can update the "Items" column to NULL for all rows in the table using a simple SQL UPDATE statement. There's no need to use a MERGE statement for this task. Here's the SQL statement to achieve this:

UPDATE YourTableName
SET Items = NULL;

Replace YourTableName with the actual name of your table. This query will set the "Items" column to NULL for all rows in the table, effectively clearing the "Items" column for all records.

Cr Bhargavi3y ago

MERGE INTO product AS Target
USING (SELECT ID FROM product) AS Source
ON Target.ID = Source.ID
WHEN MATCHED THEN
  UPDATE SET Target.Items = NULL;

Mohammad Hussain3y ago

MERGE INTO product AS Target
USING (SELECT ID FROM product) AS Source
ON Target.ID = Source.ID
WHEN MATCHED THEN
  UPDATE SET Target.Items = NULL;